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.
 

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

Format a number as ppm 7
Changing time format 2
how to get actual percentage format instead of 100 multiplied 4
Column multiplied by a matrix 2
Custom Number Format for text 8
Conditional SUBTOTAL in XL210 Table 7
Format Number 3
format a cell when I type 10 it will multiply 10 by .585 3

Top