Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Copper Contributor

Aug 30, 2022

Rounding off

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

Formulas and Functions

Harun24HR
Bronze Contributor
Aug 30, 2022
Use =LEFT(100000,4)*1 or to refer cell use =LEFT(A1,4)*1

Share

Resources