Here's an easy way:

Select your data then go to Data/Text to Columns, select "Fixed Width" hit
NEXT NEXTX then select "Date" in the upper right corner and in the drop down
menu select YMD and hit "Finish".

HTH
JG

"clarice" wrote:

how can a date that is set up in excel as 19900301 be converted automatically
to read 03/01/1990?