Previous Topic Next Topic

Date formats for Excel

Closed
Passenger 57 - Jun 18, 2009 at 09:58 AM
 John Franco - Jun 18, 2009 at 12:37 PM
Hello,
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?
Related:

1 response

Answer 1 / 1
John Franco
Jun 18, 2009 at 12:37 PM
Assuming 19881015 is in A1; Use DATE(year, month, day)

Do it this way:

=DATE(LEFT(A1;4);MID(A1;5;2);RIGHT(A1;2))

Source: http://www.excel-spreadsheet-authors.com/excel-number-to-date.html
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses