Jan 04 2022 04:54 PM
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 current year is added i.e. 11/24/2022 and is displayed as 24-Nov.
It appears the double quotes on the text date field is being ignored in Excel. The Text qualifier: field is set to ". How to get my text date imported as text? What needs to be in the .csv file, other than the double quotes, so Excel will know to keep the text date in the text format.
The csv file created using "java-script" (Microsoft will not let me use the proper name for the programing language?!?!) from proprietary software.
Jan 04 2022 10:37 PM
@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.