Assuming your first date is in A2, put this formula in the 2nd row of a help
column...

=DATE(RIGHT(A2,2),MID(A2,FIND("-",A2)-2,2),MID(A2,FIND("-",A2)+1,LEN(A2)-3-FIND("-",A2)))

and copy it down through all the rows that have dates in them. Then select
all the dates in this helper column and Edit/Copy (or Ctrl+C) them; then
select A2 (the first cell containing the original date) and click
Edit/PasteSpecial in Excel's menu bar; select Values from the option list
and hit OK; then delete the helper column and format the newly copied dates
however you want them to look.

Rick


"JR Hester" wrote in message
...
I am out of ideas. Excel„¢ XP on WinnXP.
I have acquired a spreadsheet "database" from another user. approximayely
5K
records with dates in the dddd, m-d-yy format, although these appear to be
stored as text. Changing the format does not change theway data is
displayed.
Cells were originally formatted as General.

Can anyone offer a simple formula method to change these text entries into
a
true date format? I am in process of importing info into an Access„¢
database.

Thanks for any suggestions