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-07 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 d...@premor.net wrote: try this Sub xcv() Dim Data As Range, Rng As Range Set Data = Range(A6) Set Data = Range(Data,

$$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*

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 chhajersand...@gmail.comwrote: 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

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

2013-10-05 Thread Sandeep Kumar Chhajer
: Sat, 5 Oct 2013 12:55:31 To: excel-macrosexcel-macros@googlegroups.com 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 chhajersand...@gmail.comwrote: Dear Excel

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

2013-10-05 Thread ashish koul
$$ Identifying Excel number format can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer chhajersand...@gmail.com 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

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

2013-10-05 Thread Sandeep Chhajer
-macrosexcel-macros@googlegroups.com *ReplyTo: * 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 chhajersand...@gmail.com wrote: Dear Excel Gurus, I have facing

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 chhajersand...@gmail.com Date: Sat, 5 Oct 2013 15:14:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format PFA the original

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

2013-10-05 Thread xlstime
*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 chhajersand...@gmail.com wrote: Dear Excel Gurus, I have facing a peculiar problem related to number format. When I export any ledger from tally

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, Sandeep