Custom numbers
 

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

Custom numbers
 

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
--
Cheers,
Shane Devenshire


"Tigerxxx" wrote:

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