| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncating whole numbers - diplaying thousands instead of full num
I am trying to show numbers in a spreadsheet as thousands instead of the
whole number. i.e. shw 3,000,000 as 3,000 - I cannot find a function that allows me to dothis. I need to apply the format to the entire worksheet but not loose the entire original number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Truncating whole numbers - diplaying thousands instead of full num
One way:
Format/Cells/Number/Custom 0, In article , Reez wrote: I am trying to show numbers in a spreadsheet as thousands instead of the whole number. i.e. shw 3,000,000 as 3,000 - I cannot find a function that allows me to dothis. I need to apply the format to the entire worksheet but not loose the entire original number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers truncating | Excel Discussion (Misc queries) | |||
| Format numbers to thousands | Excel Discussion (Misc queries) | |||
| Truncating numbers | Excel Worksheet Functions | |||
| How do I format numbers in thousands? | Excel Discussion (Misc queries) | |||
| How do I format numbers in thousands? | Excel Discussion (Misc queries) | |||
Linear Mode
