Round data to millions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to round full number data to millions with one decimal without using a formula to divide by 1000000? For instance, the cell contains 365,705,546 and I want to show it rounded to millions as 365.7. I remember reading a way to do this but can't find it now.
 
Hi
one way: apply the following custom format to this cell:
#,##0.0,,
-----Original Message-----
Is there a way to round full number data to millions with
Click to expand...
one decimal without using a formula to divide by 1000000?
For instance, the cell contains 365,705,546 and I want to
show it rounded to millions as 365.7. I remember reading
a way to do this but can't find it now.
 
JKP, from Excel's help file: "to scale a number by a multiple of one
thousand, include a comma in the number format." So to accomplish what
you're asking, apply the custom number format 0.0,,

When you have some time, search "Custom Number Format" in Excel help.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


JKP said:
Is there a way to round full number data to millions with one decimal
Click to expand...
without using a formula to divide by 1000000? For instance, the cell
contains 365,705,546 and I want to show it rounded to millions as 365.7. I
remember reading a way to do this but can't find it now.
 
Hi JKP,

The other replies you've been given show how to round the displayed result,
rather than the value itself. If you need to round the value, try:
=ROUND(A1/(10^6),1)
where the value to be rounded is in A1.

Cheers


JKP said:
Is there a way to round full number data to millions with one decimal
Click to expand...
without using a formula to divide by 1000000? For instance, the cell
contains 365,705,546 and I want to show it rounded to millions as 365.7. I
remember reading a way to do this but can't find it now.
 
Back
Top