Rounding Millions

[Christine]

Hello,

How do you round dollars in million to one decimal place?
For example, $105,256,256 to $105.3

Thanks,
Christine

 

[Bob Phillips]

Christine,

If you want a value of 105.3 then use

=ROUND(A1,-5)/100000

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Mike Lewis]

Christine, divide by 1,000,000 and then round to 1 decimal:

=ROUND(G7/10^6,1) where g7 is the value

good luck

 

[Frank Kabel]

Hi
and if you need it ONLY displayed this way (but leave the underlying
number untouched) use a custom format like
0.0,,