I have an Excel file, which I must share between two computers.
The file was generated on Excel-97 and will be updated on Excell-2000.
How must I save the file (with changes made in Excel-2000) so that I
am able to work on the file again in Excel-97?

i have a coloumn of names in different formats
example
Mr Paul Jones
Mr R Wright

Anyone know a compound annual growth rate formula?

Is it possible to turn autocomplete off for just 1
workbook?  When I try to do this, it turns is off in all
my workbooks, which is not acceptable.
I am using the formula =LEN to count characters in a cell

I'm trying to do a VLOOKUP command and would like to use
a cell to specify the sheet name containing the array.
Command would be =VLOOKUP("A",B1!a1:c3,2) where B1 is a
cell in the current sheet that would contain the sheet

Wondering if any of you gurus out there could help me.
I have a large spreadsheet, that I will be sharing with
my team and will therefore protect certain cells that are
the result of their data imput.

was wondering if anybody can show me an example of how to
write a function for the GOALSEEK function in Excel 2002.
thanks.

how could i word this:
i want an if statement that'll look at a cell (lets say D2) and say "if D2
is less than 10am, enter 'Before 10am' in F2, if D@ is greater than 10am but
greater than 3pm, enter 'Between 10am & 3pm' in F2 and if D2 is greater than

I have a date: 01/23/04 0:00 which is the midnight hour beggining that date. The formula looks like so: =DATE(YEAR(NOW()),1,1) I would like to make the actual date be 01/23/04 7:00 AM and 01/23/04 6:59:59 AM. Since it only adding a fraction of time in hours and minutes, how can I ...

When selecting a cell, a drop down menu of selections appears and they are the ONLY choices.  How do I edit the choices???

How can I create a new function like G(x)=5*x+4*x*x+sin(x), save it as a new function, and use it anywhere else like any other standard function (like :SUM() and SQR(x))x

I was wondering if someone could help, I am trying to
devise a way to get particular data out of an excel Cell.
This is a copy of the data that varies
1st Cell Example

Hi probably a silly question here but I can't figure it out.  I am
trying to make a table where I have two numbers say A3 and A4 and have
them multiplied to give the product in A5....this I can do for one
cell at a time.  Is there a way to format the formula so it will

I have struggled with this problem for several days and now hope that
someone can offer some help.
I need to do some calculations for some rental equipment we are using. I
have an extensive electronic table with equipment descriptions and rates.

I have the following data set out as follows in a
worksheet:
Date received    Date Sent    Difference in Days
01/12/03         08/12/03     7 (=Date sent-Date received)