Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format millions in thousands with comma
I currently have the number (in general format)
20307710.83 but I want it to be $20,308 I am currently using this as my format _($* #,_);_($* (#,);_($* "-"??_);_(@_) but that only results in $20308 How do I add the comma? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format Doe,John to Doe, John (space after a comma) | Excel Worksheet Functions | |||
How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) | |||
.CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |