Rounding value from millions to decimal places

[Bagia]

Hello,

Is there a way to round a value that is currently displaying in millions to
a value with decimal places? Example, if my current value is 8,500,000 I
would like to now display it as 8.5 millions

Thank you

 

[Jacob Skaria]

Do you mean

=A1/1000000 & " millions"

If this post helps click Yes

 

[Bagia]

Sorry,

I would like to display just 8.5

Do you mean

=A1/1000000 & " millions"

If this post helps click Yes

 

[Teethless mama]

Try this:

Conditional Formatting

0.0,,"Millions"

 

[Luke M]

I think you meant "Custom formatting".
;-)

 

[Luke M]

Custom format:
0.0,,

 

[Bagia]

Thanks to everyone who responded. This is exactly what I need. Thank you!