Hmmm...

with dates in the dddd, m-d-yy format

My dates are text such as Sunday, March 3, 2002
Wednesday, April 11, 2004

Well, I went by your first post:

with dates in the dddd, m-d-yy format

Meaning: Wednesday, 11/14/07

So, I don't think T to C will work on

My dates are text such as Sunday, March 3, 2002
Wednesday, April 11, 2004


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
If these are indeed TEXT entries you can use Text to Columns to convert
them. You'll lose the dddd portion but retain the date portion.

Select the range of cells in question
Goto the menu DataText to Columns
Select DelimitedNextselect both Comma and SpaceNext
In Step 3 the first partition should be highlighted in the data preview
box.
Select Do not import
Finish

--
Biff
Microsoft Excel MVP


"JR Hester" wrote in message
...
I am out of ideas. ExcelT 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 AccessT
database.

Thanks for any suggestions