how to convert million(1,000,000.00) to 1.00

J

Jon

Hi,
I want to convert 1,000,000 to 1.0 and round down the numbers of 1.56 to 1.6
and so on, how to do that please?
 
D

David Biddulph

=ROUND(A1/1000000,1)

Note that what you showed was not rounding DOWN, but rounding to the
nearest.
If you want to round down (to 1.5 in your example), use
=ROUNDDOWN(A1/1000000,1)
 
F

Fred Smith

To "convert" 1,000,000 to 1.0, divide by 1,000,000, as in:
=a1/1000000

If you want to display only millions, use a custom format like:
0.0,,

If you "round down" 1.56, you get 1.5, not 1.6. Did you mean "round" 1.56 to
1.6? Or, did you want to display only one decimal place? If so, the above
format will do that. If your numbers get into the billions, use:
#,##0.0,,

Regards,
Fred
 
G

Gord Dibben

Multiply by 1,000,000 to get real number 1.0

Custom format #,,.0 to get appearance of 1.0


Gord
 

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

Top