Forum Discussion

PeterFenton's avatar
PeterFenton
Copper Contributor
Jan 28, 2021

CSV Download from Website into Excel , Excel Keeps converting the dates incorrectly

Hi,

I'm download CSV files from the web using some code I found , it all works fine the website opens uploads the csv file and closes it .

The problem is the CSV  has the date  01/02/2019   ie the 1st Feb 2019  but when it is copied into excel ,  excel converts it to 02/01/2019  and reads it as 2nd jan 2019

02/02/2019  works fine but then   03/02/2019  becomes 02/03/2019  etc

 

A real pain as the webscrape of the csv file was the quickest method of downloading the csv file rather than having to go to the website each time .

 

If I do the process manually it works fine 

 

Be grateful for some help

Resources