Home > Back-end >  How to convert a text date into the short date format in excel
How to convert a text date into the short date format in excel

Time:12-28

I have a database of dates that I need to map to another table in my MySQL database. The format of one table is listed as:

Dec 01 2020

And the other is listed as:

12/01/2020

My plan is to take all the text dates from table 1, convert to short date in excel, create a new table in MySQL, then re-map them to the short date in table 2. How can you convert the text date in excel so that it matches the format of the short date (12/01/2020)? I have tried using text to columns and other date functions in excel but have had no luck. Thanks in advance!

CodePudding user response:

One can use REPLACE to place a , after the day number and Excel will then be able to convert it to a date. Then Simply format it as desired:

=--REPLACE(A1,7,0,",")

enter image description here

  • Related