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!
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!