Losing formatting when inserting into text

[dwturner]

Excel 2003

I want to create some text that includes the contents of a cell, whose contents are formatted as $. When I do so the numeric value is inserted but without the $ or the commas.

For example, in cell A1 is a calculated value of $100,000. In cell A2 I want, say,

So the amount of $100,000 is what you owe me.

where the '$100,000' comes from A1.

Thanks in advance.

 

[VoG]

Hello and welcome to MrExcel.

Try

="So the amount of "&DOLLAR(A1,0)&" is what you owe me"

 

[dwturner]

Thanks so much! And for the fast response! Of course it worked. (Helps when you know the functions available.)

This will save me a lot of time.