Inserting cell values into a sentence.

Simmo1313

New Member
Joined
May 4, 2015
Messages
39
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

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,511
Office Version
2010
Platform
Windows
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"
 

Forum statistics

Threads
1,082,478
Messages
5,365,786
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top