On Wed, 14 Nov 2007 14:36:02 -0800, JR Hester
wrote:

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


=--MID(A1,FIND(",",A1)+2,255)

Format as date
--ron