| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format number / 1000
Hi,
I wanderif there is a format (personalized) in Excel that would display a number as the number divided by 1000. For example, 1 000 000 would appear as 1 000 (or 1,000,000 as 1,000). Something like the % format that multiplies the number by 100 to display it. Thanks -- Jac Tremblay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to divide a number with "less than" sign? ie: <1/1000 = <0.001 | Excel Worksheet Functions | |||
| 1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
| Format numbers in multiples of 1000 | Excel Worksheet Functions | |||
| How to convert number in word format like (1000 i.e. One Thousand | Excel Discussion (Misc queries) | |||
| if a number is less than -1000 in Excel 2003 | Excel Worksheet Functions | |||
![Jac Tremblay[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
