Forum Discussion
How do I get a .csv file, text formatted date to not to be converted to the date format in Excel
When I import a .csv or a .txt file into Excel the text formatted date, i.e. "Nov-24" (2021) (double quotes are in the file, 2021 is not) the text is converted to the date format and the cur...
Vaden_ In Step 3 of 3 in the text import wizard, select the column that has the "Month-Day" in it and set the data format to be Text.
Alternatively, import the CSV file via Power Query. Much more robust an flexible.