| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number formatting
I need to format numeric - decimal 9.0
size 15 i.e. 1.50 = 000000001500000 Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number formatting
Given your example, this will display the number as TEXT
=TEXT(A1*10^6,"000000000000000") If you want it numeric, multiple by 10^6 (10 to power 6) and Format=custom=000000000000000 HTH "pm" wrote: I need to format numeric - decimal 9.0 size 15 i.e. 1.50 = 000000001500000 Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number formatting | Excel Worksheet Functions | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| Number formatting | Excel Worksheet Functions | |||
| Number formatting | Excel Discussion (Misc queries) | |||
Linear Mode
