custom number format

C

choi4u

When I use a custom format "#,", it displays 20000 as 20 (as if E-3
has been multiplied).

how to do a similar work to display 0.00002 as 20 (as if E+6 has been
multiplied) ?

thanks in advance.
 
P

Prashant Runwal

Not possible using custom format. Create additional column besides the cell
and use formula to multiply that cell by 1000000. If you want to convert the
existing column itself then write 1000000 in any cell. Copy this cell. Select
cells you want to convert. Then use paste - special - multiply.
 
Top