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



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


"Jon" <Jon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9C7DC898-5B79-4F98-8F45-6340C692E403@xxxxxxxxxxxxxxxx
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?


.