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

%3CLINGO-SUB%20id%3D%22lingo-sub-2107212%22%20slang%3D%22en-US%22%3ECSV%20Download%20from%20Website%20into%20Excel%20%2C%20Excel%20Keeps%20converting%20the%20dates%20incorrectly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2107212%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20download%20CSV%20files%20from%20the%20web%20using%20some%20code%20I%20found%20%2C%20it%20all%20works%20fine%20the%20website%20opens%20uploads%20the%20csv%20file%20and%20closes%20it%20.%3C%2FP%3E%3CP%3EThe%20problem%20is%20the%20CSV%26nbsp%3B%20has%20the%20date%26nbsp%3B%2001%2F02%2F2019%26nbsp%3B%20%26nbsp%3Bie%20the%201st%20Feb%202019%26nbsp%3B%20but%20when%20it%20is%20copied%20into%20excel%20%2C%26nbsp%3B%20excel%20converts%20it%20to%2002%2F01%2F2019%26nbsp%3B%20and%20reads%20it%20as%202nd%20jan%202019%3C%2FP%3E%3CP%3E02%2F02%2F2019%26nbsp%3B%20works%20fine%20but%20then%26nbsp%3B%20%26nbsp%3B03%2F02%2F2019%26nbsp%3B%20becomes%2002%2F03%2F2019%26nbsp%3B%20etc%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20real%20pain%20as%20the%20webscrape%20of%20the%20csv%20file%20was%20the%20quickest%20method%20of%20downloading%20the%20csv%20file%20rather%20than%20having%20to%20go%20to%20the%20website%20each%20time%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20do%20the%20process%20manually%20it%20works%20fine%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBe%20grateful%20for%20some%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.