$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-22 Thread Dhananjay Pinjan
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 wrote: > > Dear Dhananjay, > > YOu can do a simple

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dilip Pandey
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

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
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 wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone pr

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
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 wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone prov

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread johnson john
its simple. use is error function. Pl. see the attachment. tx., On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > 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 requirement in the

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Dilip Pandey
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 wrote: > Dear All, > > Please ignore the previous mail sent b

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Kavlya
Dear Dhananjay, Please change"-" to 0 & do formatting _(* #,##0.00_);_(* (#,##0.00);_ (* "-"??_);_(@_) Regards, Prashant On Aug 16, 8:54 am, Dave Bonallack 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 > just as well,

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Manish Purohit
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 [mailto:excel-

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Aindril De
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 -. Hop

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-15 Thread Dave Bonallack
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: dppin...