| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display to thousand
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display to thousand
1. Type 1,000 in another cell.
2. Copy (Ctrl+C) 3. Select No.s; 4. Paste Especial (Alt+E and then S) 5. Select Divide in Operations section; 6. Hit Enter "sh" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display to thousand
You can also use, if you don't want to roundup, for a cell like A1=
=Rounddown(a1,0)/1000 "FARAZ QURESHI" wrote: 1. Type 1,000 in another cell. 2. Copy (Ctrl+C) 3. Select No.s; 4. Paste Especial (Alt+E and then S) 5. Select Divide in Operations section; 6. Hit Enter "sh" wrote: 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 |
|
#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 |
| Reply |
| 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) | |||
Hybrid Mode
