Custom numbers

T

Tigerxxx

Hello,
In excel I know of customizing number formats by selecting "Formal Cells"
--> "Number" --> ""Custom"

What format should I write under Custom to display a small number as a
bigger number
i.e.
I want to display the number 0.0023 as 23

Thank you
 
S

ShaneDevenshire

Hi,

I don't believe this can be done with formatting unless you are willing to
display in scientific notation, in which case the code would be 00E-4.

The standard solution would be to multiply all the number by 10000. You can
do that with a single command - Copy a cell containing 10,000 and select the
range you want to convert and choose Edit, Paste Special, Multiply
 

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

Custom Number Format for text 8
Assign custom number format to the ribbon 0
custom formating numbers 1
Formating Large number as date 8
2007: Number format <> Number format 1
Auto Enter a Number into a Cell 6
Custom format 1
Cell Formats 1

Top