$$Excel-Macros$$ Decimal greater than 0.5

Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or 13.51(decimal equal or greater than .5) should be 14. -- -- Some important links for excel users:

Re: $$Excel-Macros$$ Decimal greater than 0.5

Hi, try Round formula Example Below =ROUND(A1,0) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:54 PM, Skanda skanda.pokkun...@gmail.com wrote: Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or

RE: $$Excel-Macros$$ Decimal greater than 0.5

You can also use this : =MROUND(B5,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 10:07 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Decimal greater than 0.5 Hi, try Round