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 ...
OK... I found a solution (That I do not like).
I live in Canada so I had set my "Preferred languages as English (Canada) first, and English (United States) as second. I set the Country or Region to Canada, and finally the Regional format to English (Canada). THEN, I change all of these things to United States - first, and change the short date to mm/dd/yyyy. THEN, my csv opens with the date as a date (not TEXT). Changing just the short date (and not the others) --- does NOT work.
I live in Canada so I had set my "Preferred languages as English (Canada) first, and English (United States) as second. I set the Country or Region to Canada, and finally the Regional format to English (Canada). THEN, I change all of these things to United States - first, and change the short date to mm/dd/yyyy. THEN, my csv opens with the date as a date (not TEXT). Changing just the short date (and not the others) --- does NOT work.
- by the way... I am not moving to the United States (even if my computer thinks we did).