| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round number to the thousands without changing underlying number
I have a number in a cell, for example 1,234,567. I want this number to
display as 1,234,000. but I do not want the number in the cell to change. I do not know how to do this with the format cells function. Does anyone have any idea how to make this happen. The ROUND function changes the underlying data. That will not work for me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| How do I format a number to cut off the thousands? | Excel Discussion (Misc queries) | |||
| How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
| how do I display number in thousands; i.e diplay 123,500 as 124? | Excel Worksheet Functions | |||
| assume the number I type is in the thousands | Excel Discussion (Misc queries) | |||
Threaded Mode
