Any way to round using number format codes?

S

sert

I'd like to have numbers displayed as being rounded up to the
next 5000.

So, if a cell contains 92,345...I'd like it to display 95,000.

Is there any way to do this with just number format codes (instead of
with the worksheet fxns?)

Thanks in advance.

sert
 
M

Myrna Larson

Not with format codes. You can display in thousands but not to the nearest
5000.
 
Top