Try combining with FIXED function.
EX. 8,500,000 in cell A1
=FIXED(A1/1000000,1,1) --- result (8.5)
=FIXED(A1/1000000,1,1)&" millions" --- result (8.5 millions)
Where A1 is the reference cell divided by 1,000,000 to get it to the decimal point you want, 1 is the number of decimal points you want it cut off to, and 1 indicates that you do not want commas included in the number. You can change the last 1 into 0 and it will include commas. For example if you want to do 8,500.0 you can do =FIXED(A1/1000,1,0).
Quote:
Originally Posted by 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
|