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

Copper Contributor

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

2 Replies

@PeterFenton You mention "using some code I found". What code? Are you importing via the "Text-to-columns" wizard or Power Query. Both allow you to specify the date format upon import.