ERROR
 

I was emailed an excel sheet. It has dates on it like 2/28/00 and I have the
option of converting it from xx to xxxx but when i do that, i cannot use them
in formulas unless i type in the date again. Anyway to not have to do that
but make the dates usable? Thanks

Hi!

One possibility is that the dates are actually text. Try
this:

Select the cells with the "dates".
Goto DataText to Columns
Just click Next, Next, Finish.

Biff

-----Original Message-----
I was emailed an excel sheet. It has dates on it like
2/28/00 and I have the
option of converting it from xx to xxxx but when i do
that, i cannot use them
in formulas unless i type in the date again. Anyway to
not have to do that
but make the dates usable? Thanks
.