Rounding

[michael]

I am trying to round into the millions. For example, I want to format
5,450,000 to 5.5
Everything I have tried so far is to the thousandth which gave me 5,450.

 

[Titus]

try
=roundup(5450000,-5)/1000000)

that should do the trick

 

[Guest]

Try this:

=CEILING(A1,10^5)/10^6

 

[Guest]

If you just want to do this via cell formatting, without changing the
underlying value, try this custom format

0.0,,