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
Dear Ashish,
This is only original file, I have just cut down the number of entries to
certain extent as I am checking my code with lesser data.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date:
i can't see custom format
On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer
chhajersand...@gmail.com wrote:
**
Dear Ashish,
This is only original file, I have just cut down the number of entries to
certain extent as I am checking my code with lesser data.
Sent on my BlackBerry®
PFA.. solved
On Sat, Oct 5, 2013 at 11:23 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Please find the attachment.
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please
attachment missing !
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please find the attachment.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464
--
Are you =EXP(E:RT) or
Hi,
Does anyone has good book/video links on dashboards. Please forward me the
details.
Thanks in advance.
Regards,
Ashwani
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Dear All
Can anyone solve my issue?
Regards
Amar
On Fri, Oct 4, 2013 at 7:05 PM, amar takale amartak...@gmail.com wrote:
Dear Experts
Pls solution my critical formula issue in excel.I hope anyone help me to
resolve this issue.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Query is not clear..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Friday, October 04, 2013 7:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Complicated Formula (automatic add back)
Dear Experts
Pls solution my
PFA the original file. Hope it will work.
On 5 October 2013 13:00, ashish koul koul.ash...@gmail.com wrote:
i can't see custom format
On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer
chhajersand...@gmail.com wrote:
**
Dear Ashish,
This is only original file, I have just cut
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
c
an you please example your requirement
please find attachment hope it fulfill your requirement
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer chhajersand...@gmail.comwrote:
PFA the original file. Hope it will work.
On 5 October 2013 13:00,
http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/
http://chandoo.org/wp/excel-dashboards/
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 2:00 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi,
Does anyone has good
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
Hi Waseem, see the suggestion using conditional formatting, only to color
the font and fill the cell.
tks.
Basole.
Em sábado, 5 de outubro de 2013 01h31min52s UTC-3, Waseem Saifi escreveu:
Hi Experts,
I want to show flag next to value's coulmn basis on criteria that if
value is
Dear Ashish,
Any further help in this matter please.
Regards
Nasir Khan
On Fri, Oct 4, 2013 at 12:38 AM, Nasir Khan nasirkhan.du...@gmail.comwrote:
Yes I did.
But as mentioned in my reply I need the code to
1) run on all the files in the given Path = Your code run a single folder
at a
16 matches
Mail list logo