Date wrong after converted in Excel [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I have data pulled from database to CSV file which can be opened with Excel. The date in the spreadsheet shows as "201003" in text format, and then "4/28/2450" after I change data format to "Date" category. "4/28" might be correct, and "2450" definitely is wrong. But I don't have access into the database to see the actual year. Can anyone help me fix it?


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
Just a guess. 201003 is actually 20 October 2003
One need more data to confirm

select the column
Go to Data and choose Text to column
Choose delimited and click next
clear all check box and click next
click on date and choose DMY and click on finish
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month