Round(a1,-3) will round to the thousands,
Round((sum(a1:a39)),-3) will round the total to thousands
but I do not know what you mean by 'x-foot'
--
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