Number Display

[Gerrym]

I have the number 36789.56 in Cell B2 The sheet should be
in 000's so I would like to display 37. How can I do
this.
Thanks

 

[Lynxbci3]

you could do :-

INT(B2/1000

 

[Lynxbci3]

oops

INT(b2/1000)+1

Sorry about tha

 

[Frank Kabel]

Hi
use a custom format like
0,

 

[Gerrym]

hanks for this, but can I round up or down to nearest 000.

 

[Guest]

Hi

Try this:
=ROUND(A2,-3)

--
Andy.

hanks for this, but can I round up or down to nearest 000.