Forum Discussion
csv
Up until a few weeks ago, I have been downloading a CSV file from a web-site. The file consisted several rows of a DATE field, text field and 2 numeric fields. EG: 08/14/2023,ABCD-1 ,005161,100.00 ...
Do you use a different system date format on the new computer than on the old one?
If you used mm/dd/yyyy on the old computer, 08/14/2023 would be recognized as the 14th of August.
If the new computer uses dd/mm/yyyy, 08/14/2023 is not a valid date, so Excel will import it as text.
I made a small error in my last replay. More correctly the computer's date format is set to: yyyy-mm-dd.
As well, I tried changing it to: mm/dd/yyyy on my Win-11 computer (then rebooted). I then tried to open my CSV file by double-clicking. Again, that DATE field opened in Excel-365 as TEXT (not as a date).
As well, I tried changing it to: mm/dd/yyyy on my Win-11 computer (then rebooted). I then tried to open my CSV file by double-clicking. Again, that DATE field opened in Excel-365 as TEXT (not as a date).