Saving Excel File to CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-1480076%22%20slang%3D%22en-US%22%3ESaving%20Excel%20File%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480076%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3C%2FP%3E%3CP%3ECould%20anyone%20please%20help%20with%20a%20solution%20to%20the%20date%20change%20when%20saving%20an%20Excel%20File%20to%20a%20CSV%20file%2C%20the%20date%20originally%20was%2022%2F06%2F2020%2C%20when%20checking%20the%20CSV%20file%20the%20date%20has%20changed%20to%2006%2F22%2F2020%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494218%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20Excel%20File%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494218%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567594%22%20target%3D%22_blank%22%3E%40Phil-365%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ETry%20the%20following...%3C%2FP%3E%3CP%3EFormat%20your%20cell%20as%20Date%2C%20in%20%22Local%20(Location)%22%20change%20whatever%20you%20have%20for%20%22English%20(United%20Kingdom)%22%20and%20select%20the%20top%20entry%20in%20type%20which%20should%20give%20you%20a%20format%20of%20DD%2FMM%2FYYYY.%3C%2FP%3E%3CP%3EThen%20input%20the%20date%20you%20want%20and%26nbsp%3Bsave%20your%20file%20as%20csv%20and%20you%20should%20be%20good%20to%20go.%3C%2FP%3E%3CP%3EIn%20the%20screenshot%20below%20I%20opened%20the%20csv%20in%20notepad%20to%20show%20you%20the%20result%20overlay%20on%20top%20of%20the%20Excel%20spreadsheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1593312034950.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201712iED3F9B07A6D78EBE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1593312034950.png%22%20alt%3D%22Bennadeau_0-1593312034950.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494262%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20Excel%20File%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Bernard%20Thanks%20for%20your%20help%3C%2FP%3E%3CP%3EI%20will%20attempt%20your%20solution%20the%20next%20time%20i%20add%20data%20to%20the%20list%3C%2FP%3E%3CP%3EJust%20out%20of%20curiosity%20a%20little%20more%20information%20I%20record%20wildlife%20data%20which%20is%20stored%20in%20Excel%20in%20a%20file%2C%20which%20i%20have%20attached%20for%20you.%3C%2FP%3E%3CP%3EThis%20file%20is%20created%20automatically%20by%20a%20program%20i%20have%20written%20in%20Excel%20VBA%20when%20the%20information%20is%20collected%20the%20Save%20routine%20at%20the%20end%20saves%20the%20file%20first%20as%20an%20Excel%20workbook%2C%20then%20as%20a%20CSV%20file%2C%20it%20is%20then%20that%20the%20date%20changes%20from%20dd%2Fmm%2Fyyyy%20to%20mm%2Fdd%2Fyyyyu%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

HI

Could anyone please help with a solution to the date change when saving an Excel File to a CSV file, the date originally was 22/06/2020, when checking the CSV file the date has changed to 06/22/2020

2 Replies

Hi @Phil-365,

Try the following...

Format your cell as Date, in "Local (Location)" change whatever you have for "English (United Kingdom)" and select the top entry in type which should give you a format of DD/MM/YYYY.

Then input the date you want and save your file as csv and you should be good to go.

In the screenshot below I opened the csv in notepad to show you the result overlay on top of the Excel spreadsheet.

Bennadeau_0-1593312034950.png

 

Ben

@Bennadeau 

Hi Bernard Thanks for your help

I will attempt your solution the next time i add data to the list

Just out of curiosity a little more information I record wildlife data which is stored in Excel in a file, which i have attached for you.

This file is created automatically by a program i have written in Excel VBA when the information is collected the Save routine at the end saves the file first as an Excel workbook, then as a CSV file, it is then that the date changes from dd/mm/yyyy to mm/dd/yyyyu