I want to extract the day (Saturday) from a date (17/11/2007) for use in a
formula to apply pay rates according to the day..
Thanks.
Bill Ridgeway

Exit from Excel edit mode using  IDispatch
I've searched Internet and groups, but can't find a solution to this.
Can anyone, please, tell, is there any way to perform exit from Excel
edit mode in programmatic way with either accepting user input or

Hi Sportsfans...
Using Excel 2003 I've got:
Cell  A1:            Last Name, First Name
Cell A2:            Street Address

In Excel 2003, if I had a pivot table open, I could go to a new workshhet,
create a new pivot table and one of the choices for the source data would be
another pivot table in this workbook. This would create a new pivot table
using the same pivot table cache.

I need a formula shen I input a dollar figure in cell A1 Cell A2 will show
the date it was added.
Thanks to all who help in advance.

In Excel 2003, I have several cells merged across columns into one cell.  I
format the cell to wrap text and want the cell (row) height to expand as
text is typed in.  When doing this in a single, unmerged, cell, it works
fine.  The text wraps and the row height expands.  When ...

I recently upgraded from Excel 2003 to 2007, and I confess to being flummoxed
by the ribbon/new menus.  Have data forms disappeared?

How do I insert "live" stock quotes into a Excel 200 worksheet?
Thanks in advance.
CW

I have the following function defining the range "Grips". (The first value
to be used in the "M" column is in Row 3.)
=OFFSET(Jobs!$M$3,0,0,COUNTA(Jobs!$M:$M),1)
I then use the name "Grips" as a validation list "Source".

My customer invoices are being made out by various people using excel.
When saving the invoices I've asked them to add the current date to the
filename when saving it,
such as AAA607 PLUS CURRENT DATE.

My graph range value is ec6:ec46
sometimes the last 4 or 5 cells at the end of the range are 0
that makes the curve go straight down
Is there a way to specify a range with only numbers greater then 0 within

I am using Excel 2003 and have a scatter chart with several series.
I would like to fill the area under each series with a different colour.
Does anyone know a way to do this?
The chart in question can be found here. It is not easily reproducible as an

I need some help how I could tackle this problem using excel 2002.
I deal with customers on a daily basis.
Every day the number of customers that I deal with are variable. One
day I deal with 20 the next 50 and the next only 10, so it is

I've got two columns with lots of data in each.  Some unique, some the
same.  Short example:
Col A
cat

I have a excel template that the user opens fills out and saves it by
giving it a filename. The problem I'm having is there is a a date field
that they need to enter in the date for that days information but they
are not filling it in. Is there a function I can put in that cell ...