| 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 | |||
Threaded Mode
