Excel Formatting

[rnordquest]

I have this in a cell:

="Initial Annual Cash Flow = " & 12*B3

This yields: Initial Annual Cash Flow = 1014.15123456789

How do I get it to display in a currency format? I want to see e.g.: Initial Annual Cash Flow = $1,014.15

Thanks,

Roger

 

[pipewelder1999]

Try this ="Initial Annual Cash Flow = " & TEXT(12*B3,"$0.00")

Have a nice day

Gerald Austin
Iuka, Mississippi

http://www.weldinginspectionsvcs.com

 

[rnordquest]

That worked perfectly. Thanks.

 

[Mutt]

See you have problem resolved but perhaps this may also be useful :
I often want numbers in process flow diagrams displayed with SI units in same cell as the number but don't want to use the text function as the number is used elsewhere or is a user input. Found quite good to use Format - Cells - Number - Custom and then enter "Inital cash flow = "$ #,##0.00 for example. May have to span (merge) across few columns for long formats if have fixed colum widths.

 

[rnordquest]

This is a better solution and I initially tried it but couldn't make it work. Syntax is everything.

 

[Mutt]

Yep, syntax can get messy. I usually format the number as I want it to look e.g. $1000,000.00 then go to the custom format and add on the text before and after. All the #,0 are then in the right places - usually