Round to nearest thousand
You will need an extra column with following formula:
=ROUND(A1,-3)
HTH
--
AP
"GillianHG" a écrit dans le message de
...
Is there a custom format I can use to round to the nearest thousand? Eg
if I
have 104580 I want it to round to 105000. I tried #,##0 but it takes off
the
last three 0's which I need to display.
Your help is appreciated!
--
Thanks,
GillianHG
|