Round data to millions

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

 

[Frank Kabel]

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

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.

 

[DDM]

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

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.

 

[macropod]

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

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.