Excel Formatting
Excel Formatting
(OP)
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
="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





RE: Excel Formatting
Have a nice day
Gerald Austin
Iuka, Mississippi
http://www.weldinginspectionsvcs.com
RE: Excel Formatting
RE: Excel Formatting
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.
RE: Excel Formatting
RE: Excel Formatting