Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number Format
Is it possible to format a number from millions to thousands. For example
12.345 to 12,345. I have found how to format in the other direction but can't work it out this way. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number Format
There's no way to do this with custom formatting. You can, of course,
multiply the cell value by 1000. In article , ASH29 wrote: Is it possible to format a number from millions to thousands. For example 12.345 to 12,345. I have found how to format in the other direction but can't work it out this way. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number Format
On Jun 12, 9:41 am, ASH29 wrote:
Is it possible to format a number from millions to thousands. For example 12.345 to 12,345. I have found how to format in the other direction but can't work it out this way. Thanks You can reduce the significant digits displayed, but you cannot increase them. You can format the number 1000000 to look like "1,000" with a #,0, or like "1 Million" with a #,##0,," Million" Alas, you cannot turn 3.14159 into 314,159 Doing so doesn't seem to have as much practical value as the reducing the precision. Formatting a number to look like "1 Million" is generally more helpful than formatting it to appear as "0.001 Billion" I recommend that you scale the number up in an adjacent column. Brian Herbert Withun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Number Format | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
custom number format | Excel Discussion (Misc queries) |