Using Excel 2003.
Problem replacing a series of dates having a date format of dd/mm/yy. I want
to replace all dates ending with /05 with /06. I enter in the Find box /05
and in the Replace box /06

The Shell command doesn't seem to work with a help file. What command will
run a help file and then return to the XL app?
Thanks,
Fred

When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent
too much.  If I add the exact numbers instead of the cell reference, then the
result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is
14,221.28).  What is adding the extra penny to give ...

Is it possible to add the actual name of the file in a new column when I
open each file with Excel.
I have multiple files that I need to have the file name included with
each row within the file.

I am attempting to create a template file that I will use for
illustration purposes.
I need help creating a formula that will calculate the investment
growth of a monthly deposit that compounds annually. Secondly I need

I have a time log I am keeping on separate clients however, I would like
to create a sheet that adds up time from each client sheet.
How do I pull time from sheet 1 and time from sheet 2 to create total
time on sheet 3?

Hi.
Would you please help me?
I use other program to manage my e-mails. How to stop outlook to be my
default mail client. I click accidentally on the button to tell outlook to be

In Excel 2000, I want to create a spreadsheet which has a column of foods, a
column of cooking times (in minutes), and a third column which calculates
the time to begin cooking that item based on an inserted mealtime. For
instance, if a mealtime of 2:00 pm is inserted manually ...

hi there i don't know if this is the right section, however I was
wondering is there some vba or formulae to generate random numbers in a
certain range
I would be very greatful if you can help me

I want to format a group of cell based on days old. The days is based on the
"value" in cell I8 =Now() and cell J10 (j11,j12...) on is the submission
date. Therefore number of days that has passed is in cell I10 (i11,i12...)
=$I$8-J10" in the cell, this is the number of days that ...

I am looking for a fomula or the method to add the total from a
particular cell in 5 sheets and enter it in a paticular cell on a 6th sheet.
I obtained a total on each sheet by =sum(A1:G1)and entered it in H1
Now I want to add H1 on the 5 separate sheets to give a total in a cell

I'm trying to filter contacts by state. I know how to use auto filter to
list all contacts in one state but I want to list contacts in 5
different states. can auto filter do this and how? Thanks

I am having a LOT of trouble with what seems to me should be a fairly
simple function.
I am setting up a sort of database for our sales department.  It
contains 16 criteria headings. At the end of each day, the manager will

I have 12 columns with numbers,these numbers change very rapidly as they
are fed into the sheet from a website.
I need a formula to calculate the max of the numbers in every second
column,for the first row this would be  the numbers in cells

I am trying to list the top 4 people based on a score.  For
hypothetical lets just say that this is my table:  Two columns A and B
A             B
Frank        7