Previous Topic Next Topic

Date wrong after converted in Excel

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 Jun 2010 à 18:56
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

Similar discussions

How to convert number into text in Excel
boratechandu -
Raj -

9 responses
Why is my Whatsapp Chat not sorted chronologically?
Kingtt -
Yeraldocaleb -

15 responses
how to convert Date into text.
rk gupta -
TrowaD -

1 response
Error while starting GTA San Andreas
Abdullah -
Junior -

9 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses