try =ROUND(A1/1000,0)

if A1 has 123,456.78 it will display 123

Also, the 'total of the above column' should show as 740, and a cell
display the rounding error if you require, to add the '123's up is
incorrect and will probably cause problems in further calculations
etc.

It is incorrect to say that 740,000 can be represented as 738 when
rounded to thousands.

Still. it is your data . . . . . .


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385486