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

  • Thread starter Thread starter Jon
  • Start date Start date
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?
 
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
 
Multiply by 1,000,000 to get real number 1.0

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


Gord
 
Back
Top