Date formats for Excel

Passenger 57 - Jun 18, 2009 at 09:58 AM
 John Franco - Jun 18, 2009 at 12:37 PM
I have a database of names and other details in Dbase IV. I migrated this database to Excel, but not all the dates are coming out well. Some dates are coming out as 19881015 instead of 15/10/1988. Is there a way of correcting this?

1 reply

Assuming 19881015 is in A1; Use DATE(year, month, day)

Do it this way: