Previous Topic Next Topic

Date wrong after converted in Excel

Closed
Mask - Jun 13, 2010 at 06:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 13, 2010 at 06:56 PM
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?


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 13, 2010 at 06:56 PM
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

Similar discussions

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

11 responses
Error while starting GTA San Andreas
Abdullah -
Junior -

9 responses
How can I convert Apple Music to MP3
nikigreen -
nikigreen -

8 responses
GTA: SA says "Wrong Disk Inserted"
Jhaz -
Feelbad DZ -

1 response
why does GTA san andreas stuck
gabriel -
HelpiOS -

1 response