Forum Discussion

Phil-365's avatar
Phil-365
Copper Contributor
Jun 22, 2020

Saving Excel File to CSV

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

Macros and VBA

2 Replies

  • Bennadeau's avatar
    Bennadeau
    Iron Contributor
    Jun 28, 2020

    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.

     

    Ben

    • Phil-365's avatar
      Phil-365
      Copper Contributor
      Jun 28, 2020

      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

Resources