G
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
in 000's so I would like to display 37. How can I do
this.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lynxbci3
you could do :-
INT(B2/1000
INT(B2/1000
L
Lynxbci3
oops
INT(b2/1000)+1
Sorry about tha
INT(b2/1000)+1
Sorry about tha
F
Frank Kabel
Hi
use a custom format like
0,
use a custom format like
0,
G
Gerrym
hanks for this, but can I round up or down to nearest 000.
G
Guest
Hi
Try this:
=ROUND(A2,-3)
--
Andy.
Try this:
=ROUND(A2,-3)
--
Andy.
Gerrym said:hanks for this, but can I round up or down to nearest 000.