Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format Numbers to $$ | Excel Discussion (Misc queries) | |||
custom formating numbers | Excel Discussion (Misc queries) | |||
custom numbers | Excel Discussion (Misc queries) | |||
custom formatting numbers | Excel Worksheet Functions | |||
Custom Format for Numbers | Excel Discussion (Misc queries) |