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
It is really nice,
but for undesrstanding can you please guide that what is the use of ?
Where we need to put this?
Regards,
Darshil Shah.
On Tue, Aug 11, 2009 at 4:42 PM, soura...@gmail.comsoura...@gmail.com wrote:
Hi Ruchi
Here is formula for your reference
=A1 A2 A3
On Aug 11,
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
Hi,
I have to replace ! in the workbook, you can use what ever you want in
place of !. But the find and replace did not work for me. Then i use a
alternate method for this. See the steps below.
1). find ! in cells using Edit-find (just want to know the columns which
has !). After this I
Dear Ayush,
It is really helpful nice one..
But I am not able to select next month.. when i have selected calendar
it is coming August-2009,but i need calender for September which i am
not able to drag down in same calendar.
Regards,
Darshil Shah.
On Fri, Aug 7, 2009 at 7:49 AM,
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 Abdul,
I think we don't need to use the below code due to which it changes those
cells since a non-numeric found and as soon as a non-numeric cell encounters
it exit the macro due the following lines of code.
Else
Exit Sub
End If
Bakul,
Try the below code:
Sub
We can do the subtotal in one cell only.
Find the attached excel file for the solutions
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com
Dear all,
Any idea how to make .tsv file.
Either by office or any other tool.
I want to make a tabular format with file extension .tsv
Any help
Rgds,
A Hakim
--~--~-~--~~~---~--~~
Dear Shah,
Use of explained below -:
1.) To seperate a references / texts in the formula result
2.) To include some text in - between the references results.
Note:- Between formulas / References you can use to include any
text or space. e.g. reference 1 dilip reference 2
Let me know
Hi Prashant,
You can refer to the attached file.
In order to achieve the task, you need to first unlock all the cells
(Select whole tab, and uncheck the Locked checkbox under Protection
tab in cell format option). Now select the highlighted tab, and check
that box. Finally you need to protect
Hi Umesh,
You can discuss the same, no problem. But I would suggest if you can
go ahead and post the same to the group, marking me in the CC field.
There are many great minds who would also be intersted to help you
out.
Group Mail Id:- excel-macros@googlegroups.com
Thanks,
Dilip Kumar Pandey
Hi Dhananjay,
Same to you and to all of our great frnds...Happy Independence Day.
(Belated)...!!
--
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:
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
Dear Manish,
I tried the same, but my objective is not to allow users to use filter of
the cell A1, they may use any of the visible cell except A1
Please advise further
Regards,
Prashant
|
Manish Purohit to excel-macros
show details 8:25 AM (10 hours ago)
Reply
[image: Follow up message]
Dear All Excel Gurus,
Kindly help on the problem in the attached sheet.
I need formula for ranking , punches as per day/time
Regards,
Prashant
--~--~-~--~~~---~--~~
--
Some
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
Friends...can you help me for maintain daytoday mis.. we face many problem
to maintain thousand of data in excel..
we discuss on that..
--
--
Warm Regards,
You mesh
--~--~-~--~~~---~--~~
thanx ...definatly i will do this.
On Sun, Aug 16, 2009 at 11:14 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Umesh,
You can discuss the same, no problem. But I would suggest if you can
go ahead and post the same to the group, marking me in the CC field.
There are many great minds who
how do u do it. Thx
On 8/16/09, Dilip Pandey dilipan...@gmail.com wrote:
Dear Mahesh,
Please find the unprotected file. I have removed Worksheet passwords
+ VBA Password. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
On Aug 15, 9:48 pm, Dhananjay Pinjan dppin...@gmail.com
wrote:
Dear All,
Can anyone provide me the solution as per the requirement
in the
attachment.
Thanks in advance Regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
Hi Dhananjay,
No need for any special formatting!
Please refer
21 matches
Mail list logo