Rounding value from millions to decimal places
I think you meant "Custom formatting".
;-)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Teethless mama" wrote:
Try this:
Conditional Formatting
0.0,,"Millions"
"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
|