MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula Format


Posted by Rob on June 22, 2001 3:26 PM

Question: I have a cell which has the following formula: ="Balance Pending: " & F100 . I would like the F100 to be formatted as a Currency. If I format the whole cell as a currency, it does nothing because there is text in it also.

Any help is appreciated,
Thanks.


Posted by Aladin Akyurek on June 22, 2001 3:28 PM

How about:

="Balance Pending: $" & F100

Aladin

==========

Posted by Rob on June 22, 2001 4:42 PM

That doesnt format the number

Aladin,
That puts a $ in front, but doesnt format the number as a currency. ie: $50,000.00 . I need the commas and 2 deciaml places.

Posted by Aladin Akyurek on June 22, 2001 5:18 PM

TEXT

Rob

Use this one:

="Balance Pending: " & TEXT(F100, "$000,0.00")

Aladin

=========

Posted by Rob on June 23, 2001 1:47 AM

ah yes, thanks much

Replace the 0's with # and there it is. I appreciate the help :)