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 :)
