Great Solution Mr. *Aindril De.*
*That's what I am serching for.*
Please can you tell me in detailed (or send a link) about Custom
Formatting which is a very powerfull in Excell.
Thanks in advance.
Regards,
Dhananjay
On 8/16/09, Aindril De aind...@gmail.com wrote:
Dear Dhananjay,
YOu can
Hi Dhananjay
Please find herewith excel file as per your requirement.
U just set the currency 0=-
Dhartikumar
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can
Hi Dhananjay
Please find herewith excel file as per your requirement.
U just set the currency 0=-
Dhartikumar
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can
Hi Dhananjay,
Thanks for encouraging words.
This is done using custom format. Whenever you type in zero, it will treat
that as -.
Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 17, 2009
Dear Dhananjay,
YOu can do a simple change in the formatting of the cells.
Select the table, use custom format and choose General.
Paste the following formatting.
General;General;_-* -??_-;_...@_-
Click oK.
Now change all - with 0 . you will notice all 0 values will be represented
as -.
Hope
Hi Dhananjay,
Find the attached excel file with the solution.
You can use N( ) to treat any string as 0.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com
Dear Dhananjay,
Please change- to 0 do formatting _(* #,##0.00_);_(* (#,##0.00);_
(* -??_);_(@_)
Regards,
Prashant
On Aug 16, 8:54 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Have a look at the attached.
I've used SUMIF. But I don't know why you don't want to use SUM. It works
Hi Dhananjay,
Solution is attached as per your requirements. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/15/09, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear All,
Please ignore the
its simple. use is error function.
Pl. see the attachment.
tx.,
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can anyone provide me the solution as per the
Hi,
Have a look at the attached.
I've used SUMIF. But I don't know why you don't want to use SUM. It works just
as well, and is simpler. They are the results in red.
Regards - Dave
Date: Sat, 15 Aug 2009 17:21:35 +0530
Subject: $$Excel-Macros$$ Fwd: about to remove #VALUE! error
From:
10 matches
Mail list logo
