RE: $$Excel-Macros$$ Identifying Excel number format

2013-10-08 Thread Sandeep Chhajer
. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 05 October 2013 16:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format c an you please example your requirement please find attachment

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-06 Thread Sandeep Chhajer
Dear De Premor, Sorry for the late reply. Your code is running perfectly. Thanks for the code. On 5 October 2013 18:22, De Premor wrote: > try this > > Sub xcv() > Dim Data As Range, Rng As Range > > Set Data = Range("A6") > > Set Data = Range(Data, Data.End(xlDown)).Offset(, 4)

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread De Premor
try this Sub xcv() Dim Data As Range, Rng As Range Set Data = Range("A6") Set Data = Range(Data, Data.End(xlDown)).Offset(, 4) For Each Rng In Data Rng.Offset(, 2) = Rng * IIf(InStr(1, Rng.NumberFormat, "Cr") > 0, -1, 1) Next End Sub Pada 05/10/2013 14:23, Sandee

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread xlstime
ps.com >>> *Date: *Sat, 5 Oct 2013 12:55:31 +0530 >>> *To: *excel-macros >>> *ReplyTo: * excel-macros@googlegroups.com >>> *Subject: *Re: $$Excel-Macros$$ Identifying Excel number format >>> >>> can u share the orginal file >>> >>>

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Kumar Chhajer
Excel gurus, Any solution. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Sandeep Chhajer Date: Sat, 5 Oct 2013 15:14:11 To: Subject: Re: $$Excel-Macros$$ Identifying Excel number format PFA the original file. Hope it will work. On 5 October 2013 13:00

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Chhajer
l-macros@googlegroups.com >> *Date: *Sat, 5 Oct 2013 12:55:31 +0530 >> *To: *excel-macros >> *ReplyTo: * excel-macros@googlegroups.com >> *Subject: *Re: $$Excel-Macros$$ Identifying Excel number format >> >> can u share the orginal file >> >> >> O

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread ashish koul
esser data. > > Sent on my BlackBerry® from Vodafone > -- > *From: * ashish koul > *Sender: * excel-macros@googlegroups.com > *Date: *Sat, 5 Oct 2013 12:55:31 +0530 > *To: *excel-macros > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$E

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Kumar Chhajer
:31 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer wrote: > Dear Excel Gurus, > > I have facing a peculiar problem related to numb

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread ashish koul
can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer wrote: > Dear Excel Gurus, > > I have facing a peculiar problem related to number format. > When I export any ledger from tally I got result as bellow > > > >Aditya Birla Memorial Hospital 3049.00 3049.00Aditya

$$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Chhajer
Dear Excel Gurus, I have facing a peculiar problem related to number format. When I export any ledger from tally I got result as bellow Aditya Birla Memorial Hospital 3049.00 3049.00Aditya Enterprises 99521.00 101086.00 *1565.00 Cr* Airways Corporation 39363.80 Dr *39363.80 Dr* Airway