Bohra999Copper ContributorAug 30, 2022Rounding offI want to round off 100000 to 1000 in excel. What formula should be used
1 ReplyReplies sorted by NewestHarun24HRBronze ContributorAug 30, 2022Use =LEFT(100000,4)*1 or to refer cell use =LEFT(A1,4)*1
