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

[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?

 

[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)

 

[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

 

[georgelushaka]

 

[Gord Dibben]

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

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


Gord