Incorrect date formatting

[alce]

Hi all,

I just signed up. Sorry if this question has been addressed before but I couldn't quite get the answer. I'm sure I'll get more familiar with the community as I come more often.

I have a .csv I downloaded with bank transactions for a whole year so around 3500 rows. The import shows the dates as 1032019 for January 3, 2019, and 10102019 for October 10, 2019, for example. However, when I select the column and format the text as either long or short date, the dates would show as 7/27/4725 and something about the date being too many characters long that it can't be displayed, for the October one. How could I fix to show the real transaction date of as 01/03/2019 and 10/10/2019 respectively, to be able to sort by date?

Thank you in advance!

 

[Fluff]

You could put this into another cell, change G2 to the cell with your date
=DATE(RIGHT(G2,4),LEFT(G2,LEN(G2)-6),MID(G2,LEN(G2)-5,2))

 

[Rick Rothstein]

Since your date delimiter is a slash, you could also use this formula (but you will have to manually format the cell to display the date in the form you want)...

=0+TEXT(G2,"0\/00\/0000")