.
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
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,
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*
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
: 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
$$ 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
-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
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
*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
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
10 matches
Mail list logo