to round this off, use =round(A1,-3) to round it off to 58000 where 57887 is
in A1



"tps1234" wrote:

How do I round a number to the nearest thousand (i.e. 57,887 pulled from one
worksheet, but need rounded to 58 on another worksheet.