06-21-2020 11:31 PM
06-27-2020 07:42 PM
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.
06-27-2020 09:57 PM
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