Rounding
 

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.

Rounding
 

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

that should do the trick
wrote:
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.

Rounding
 

Try this:

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


" wrote:

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.

Rounding
 

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

0.0,,

" wrote:

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.