| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
display to thousand
Use a custom format of: #,
If your data can be in the millions, and you want to have a comma separator, use: #,###, -- Regards, Fred "sh" wrote in message ... How to display a number 122,789 become 122? I want all number display up to thousand. For example, 456 instead of 456,223. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you round to nearest thousand? ie 10,000 to 10 | Excel Discussion (Misc queries) | |||
| Round to nearest thousand | Excel Discussion (Misc queries) | |||
| rounding to the nearest thousand | Excel Worksheet Functions | |||
| thousand separator | Setting up and Configuration of Excel | |||
| Thousand Seperator | Excel Discussion (Misc queries) | |||
Threaded Mode
