Date format changes

fgwall3gmailcom 

If the date format changes when using CSV conversion and the day is less than 13, it could be due to the regional settings or default date format settings in your Excel application.

Here is how you can try to fix this problem:

1. Open Excel and go to "File" > "Options."
2. In the Excel Options dialog box, select "Advanced" from the left sidebar.
3. Scroll down to the "When calculating this workbook" section and look for the "Use system separators" option.
4. Uncheck the "Use system separators" option and manually set the date format to "dd/mm/yyyy."
5. Click "OK" to save the changes.

By disabling the "Use system separators" option and manually setting the date format, you can ensure that Excel interprets the dates correctly in the desired format.

If the above steps do not resolve the issue, you can try the following additional steps:

1. Open a new blank Excel workbook.
2. Go to "File" > "Options" > "Advanced."
3. Scroll down to the "General" section and locate the "When creating new workbooks" option.
4. Select the desired date format, such as "dd/mm/yyyy."
5. Click "OK" to save the changes.

By setting the default date format for new workbooks, you can ensure that any new files you create will use the correct date format.

If the problem persists, it's possible that there might be a compatibility issue with the specific version of Excel you're using. In that case, you may want to consider updating your Excel version to the latest release or contacting Microsoft support for further assistance.