Dear Sir(s),
I want a add-in program for rounding desired decimals of large data. like .00,.000,0.
please provede me sirs.
2 Replies
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
Attached File : 112266 20150602132821 decimles.zip downloaded: 232 times
Recent Topics
- Can we issue GST debit note in case mother invoice
- ITR-U for declaring foreign assets under schedule-
- INCOME TAX NOTICE for claiming deduction and verif
- Nature of business activities -GST
- Professional Tax Karnataka in case of Ecommerce se
- Sale less than Stamp duty value
- 10F form can be submitted for the F.Y. 2025-26 now
- ITC wrongly availed
- Buyout reimbursement
- Hra exemption for jointly owned flat
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert04 February 2025
CAclubindia
