| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display figures with thousand omitted
Hi all
Wish to format a cell to display numeric figures with thousand omitted. i.e, say HK$1,789,123.00 to display as HK$1,789 How can I do that? (rather than dividing the cell by 1,000 then limit decimal places to 0) Thanks very much Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display to thousand | Excel Discussion (Misc queries) | |||
| rounding figures to nearest thousand | Excel Worksheet Functions | |||
| convert figures in to word example 350/- three thousand and fifty | Excel Discussion (Misc queries) | |||
| Dont display negative figures? | Excel Discussion (Misc queries) | |||
| In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) | |||
Threaded Mode
