convert a text date to a true date
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
|