Hi, I have a strange problem,
After scraping some data from a website and stored it into a data table, it is written into Excel. This is usually 10-15 rows. In the data table, one column is dates in the format dd/mm/yyyy. When this data is written into Excel, some cells are being formatted as "General", and some as "Date". (This is happening "by itself" when the data are written in). Then in some cells, formatted as "Date", day and month switches places. For example, 11/04/2020 suddenly becomes 04/11/2020. This seems to happen completely by random.
Does anyone have an idea why this is happening?
After scraping some data from a website and stored it into a data table, it is written into Excel. This is usually 10-15 rows. In the data table, one column is dates in the format dd/mm/yyyy. When this data is written into Excel, some cells are being formatted as "General", and some as "Date". (This is happening "by itself" when the data are written in). Then in some cells, formatted as "Date", day and month switches places. For example, 11/04/2020 suddenly becomes 04/11/2020. This seems to happen completely by random.
Does anyone have an idea why this is happening?