Dear Sir(s),
I want a add-in program for rounding desired decimals of large data. like .00,.000,0.
please provede me sirs.
chandra
(student)
(528 Points)
Replied 22 May 2015
Use '+Round(number,number of digits)' function
to round 5025 use +round(5025,-2) = 5000, you can give cell reference instead of 5025
to round 5051 use +round(5051,-2) = 5100
-2 rounds up to hundreds
You can use -3 or -4 or -5 as you require
Hope this is of any use to you
Best of luck
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 02 June 2015
HI
Install this add-in, this works in excel 2007 & above only...
Once you install add-in in Home ribbon you will get new button decimle..
To run macro you need to select cells in sheet for which you need to round numbers, then press Decimle button & you will be prompted for no. of digit to round off, enter any number and your data will be rounded accoridngly..
Thanks
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)
LIVE Course on Foreign Exchange Management Act (FEMA)(without recording)