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

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

=ROUND(#,-3), where # is the actual number or a cell reference, e.g
=ROUND(A1,-3)

"GillianHG" wrote:

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

Is there a FORMAT I can use instead? I don't want to actually round the
number (I still want to calculate on the whole number), I just want to round
the display.
--
Thanks,
GillianHG


"Ardus Petus" wrote:

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