Custom Number Format

G

Guest

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
 
J

JE McGimpsey

There's no way to do this with custom formatting. You can, of course,
multiply the cell value by 1000.
 
S

SpreadsheetBrian

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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting length of data in Excel 1
tools|options|Edit tab|fixed decimal places 1
Format significant digits 6
How to Format numbers from percentage points to basis points 1
Custom number format 4
convert number to % using only custom number format challenge 7
XL2007 French Numeric Formats 1
Best way to format 2

Top