Rounding off

[Bohra999]

I want to round off 100000 to 1000 in excel. What formula should be used

[#2]

Use =LEFT(100000,4)*1 or to refer cell use =LEFT(A1,4)*1