I am exporting a list and it contains birthdays.... the software exporting it as CSV. I load it into Excel365 and it asks me if i want to remove leading zeros or convert. This is something new because it never used to ask that before. Then my data is listed in columns, and in a weird font I never use. Usually, it uses the system font (Calibri). Everything "looks" ok. the dates though are in mm/dd/yyyy. I then save the file as xlsx so i can work with it properly.
Normally I would just change the date format to be whatever I want. However, regardless of what format I choose, nothing changes. It is as if the data is stored as text instead of numbers. If I delete the contents and manually type in a date in the cell where I changed the format, the manually entered date works.
I tried to use the text-to-columns, but that does nothing. It simply copies the data over to a new column. I never had this problem when importing data from this system before.
How can I fix my data?
Normally I would just change the date format to be whatever I want. However, regardless of what format I choose, nothing changes. It is as if the data is stored as text instead of numbers. If I delete the contents and manually type in a date in the cell where I changed the format, the manually entered date works.
I tried to use the text-to-columns, but that does nothing. It simply copies the data over to a new column. I never had this problem when importing data from this system before.
How can I fix my data?
| test.xlsx | |||
|---|---|---|---|
| A | |||
| 1 | Primary's Birthday | ||
| 2 | 5/22/1956 | ||
| 3 | 10/14/1985 | ||
| 4 | 2/16/1962 | ||
| 5 | 2/21/1978 | ||
| 6 | 1/9/1945 | ||
| 7 | 3/17/1964 | ||
| 8 | 2/12/1950 | ||
| 9 | 3/19/1966 | ||
| 10 | 4/28/1946 | ||
test | |||
