RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread Asa Rossoff
lf Of Asa Rossoff Sent: Tuesday, April 10, 2012 11:19 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Display numbers in Lakhs I think it should work to give the right comma separation, but it does not round to Lakhs. For Lakhs plus Indian comma separation, try this on

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread Asa Rossoff
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Tuesday, April 10, 2012 5:37 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Display numbers in Lakhs It is not working in Excel 2010, I am not too good in custom format.

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread Rajan_Verma
: Apr/Tue/2012 06:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Display numbers in Lakhs Hi Abhishek sir, Can u plz exclude me from this group Sent on my BlackBerryR from Vodafone _ From: Abhishek Jain Sender: excel-macros@googlegroups.com Date: Tue, 1

Re: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread prernachadha
Hi Abhishek sir, Can u plz exclude me from this group Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain Sender: excel-macros@googlegroups.com Date: Tue, 10 Apr 2012 16:40:31 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Display

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread Rajan_Verma
: Re: $$Excel-Macros$$ Re: Display numbers in Lakhs Right Click on cell...choose format cells > Custom > under the "Type:" use this - [>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 On Tue, Apr 10, 2012 at 4:11 PM, Prabhu wrote: Hi, Plz help to solve t

Re: $$Excel-Macros$$ Re: Display numbers in Lakhs

2012-04-10 Thread Abhishek Jain
Right Click on cell...choose format cells > Custom > under the "Type:" use this - *[>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 * On Tue, Apr 10, 2012 at 4:11 PM, Prabhu wrote: > Hi, > > Plz help to solve the below Query. > > > > On Sunday, January 29, 2012 11:12:26 AM UTC+5:30, Pr