Inserting cell values into a sentence.

[Simmo1313]

I have a question regarding inserting cell values into a sentence.

Lets say I have the following cell values

A1= 1,200,000
A2= 34.5267%

I have the following formula in a cell
="The value of cell A1 is "&A1&" and the value of A2 is "&A2&" respectively"

My issue is when I use this statement I cant get the comma separators in the number and I cant round the percentage value to round to 2 decimal places.

Can some one point me in the right direction?

Cheers

 

[Rick Rothstein]

I have a question regarding inserting cell values into a sentence.

Lets say I have the following cell values

A1= 1,200,000
A2= 34.5267%

I have the following formula in a cell
="The value of cell A1 is "&A1&" and the value of A2 is "&A2&" respectively"

My issue is when I use this statement I cant get the comma separators in the number and I cant round the percentage value to round to 2 decimal places.

Try it like this...

="The value of cell A1 is "&TEXT(A1,"#,##0")&" and the value of A2 is "&TEXT(A2,"0.00%")&" respectively"

 

[Simmo1313]

Thank you very much,

That's it