I need a formula to calculate the date 4.78 yrs back from 01/08/09. i
manually did which is 20/10/04. any help

When we type a letter in the cell, the cursor should move to the word
starting with that letter in the drop down list. How this can be done?

I have import data into an Excel 2007 spreadshee from a an Acess 2007
database table.  Since I do not need them to be link I then deleted
the "connection"
However the "filer" drop downs remain on the table and the filter

Here is the problem I have now I am trying to view the top 5 in a group of
data. I have been trying to use the formula as follows:
=VLOOKUP(LARGE($I$2:$I$1000,1),$I$2:$BW$1000,67,FALSE)
=VLOOKUP(LARGE($I$2:$I$1000,2),$I$2:$BW$1000,67,FALSE)

if cell A1 is reference to A10. And when i double click in cell A1 it goes
to cell A10. my question is how to come back to cell A1.

ActiveCell.FormulaR1C1 = "9/16/2009"
   Range("B1").Select
   ActiveCell.FormulaR1C1 = "9:25 AM"
   Range("C1").Select

Here is my issue I have a sheet for every day of the month and then a MTD
sheet. On every sheet Col A has the names of the Sales Rep and then Col B has
their % of sales that day. I want on the MTD sheet a formula to go through
and se first if that sales rep worked that day and if ...

I need to create a unique random number from 1-15 in columns D1 thru D15.
There can be no duplicates.  It should be a different set of numbers each
time the spreadsheet is loaded.  Can someone show me an easy way to
accomplish this?

I repaired and uninstalled then installed Office 2007. I opened Excel up and
search for my Excel Spread Sheet and open it and then save as on my desktop
like I always do. Then when I double click on the Icon I get "Windows can
not

Please some give me the formular
48,400
 8 %
30 years

I 've got my bank statement as a CSV text file but my Excel2000 fails to
recognise comma as a fiel separator and places each record into a single
cell. How do I get round this?

Thanks for reading
I have Windows Vista (wish I didn't) but when I try to save a file
from my C:\ drive to my external drive I get this error.
"Cannot save K:\blood.xls. The folder is marked as Read Only.

When I go to File Open, to retrieve an existing file,  the default
format is List, and the I change it to Details.  How can I get File
Open to always defaltto Details, instead of changing it eveytime I
want to open a file ?

I need to type plus or minus character ("+" over "-") in preparing an
Engineering document for indicating tolerances.
What is the ASCII Value for this character.
If this is not available in regular fonts...which font I should use to get