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

"Luke M" wrote:

Custom format:
0.0,,
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bagia" wrote:

Sorry,

I would like to display just 8.5

"Jacob Skaria" wrote:

Do you mean

=A1/1000000 & " millions"

If this post helps click Yes
---------------
Jacob Skaria


"Bagia" wrote:

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