Losing formatting when inserting into text

dwturner

New Member
Joined
Jul 15, 2009
Messages
4
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.
 
Last edited:

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Hello and welcome to MrExcel.

Try

="So the amount of "&DOLLAR(A1,0)&" is what you owe me"
 
Upvote 0
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.

:)
 
Upvote 0

Forum statistics

Threads
1,224,552
Messages
6,179,482
Members
452,916
Latest member
MrsMSalt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top