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,,
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.