Any way to round using number format codes?

[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

 

[Myrna Larson]

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

 

[sert]

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

Thanks Myrna.

 

[Steve H.]

Assuming 92,345 is in cell J23 use this: =CEILING(J23,5000)

Steve Hubbard

 

[Steve H.]

Sorry:

I get it. Formating not functions sorry.

Steve Hubbard