Excel changes my date format in .csv

Hi Jon Deak,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

As you know that mm/dd/yyyy is the default format in MS Excel

May I know have you tried to create a custom date format e.g. select your cells containing dates and right click and select Format Cells. In Number Tab, select Custom then type 'dd-mon-yyyy' in Type text box, then click okay. It will format your selected dates.

As you mentioned, "Excel keeps changing my date format from dd-mon-yyy to dd-mon-yy when i close and re-open it" may I know does issue happened do specific Excel document?  If the issue happens to all Excel files including a new created one, the issue is more related to the Office app itself or your computer environment. Could you please try open your Excel insafe mode which allow you to safely use it when it has encountered certain problems

In the meantime, to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here (Please mask your private message for protecting your private message) and we will be tested on that version and verify the result with you.

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad

Hi Wasqas,

Yes, I've created a custom date format for dd-mon-yyy and Excel still reverts back to dd-mon-yy when I re-open the .csv file. This issue happens to all Excel files that are in a .csv format. This was also encountered in safe mode. Below is my Excel information, thanks

Hi Jon Deak,

I go through the post carefully, I am sorry for the inconvenience this causes, I can repro the same issue on my side based on my test. It seems that Excel will convert date format dd-mmm-yyyy in CSV when opening it from Excel, this doesn’t happen when use d/m/yyyy in CSV based on my test(which is the default date format in Windows OS date format setting on my side). As CSV file is plain text file, your format changes in CSV in Excel will not save to the CSV file so next time you may also see the format change again.

I am really sorry for the inconvenience this causes and would suggest you try format the date in CSV same as short date format in Windows>Control panel>clock and Region>Change date, time or number formats>Additional settings>Date tab.

Additionally, I would suggest you provide your feedback on this to the related developer team of Excel by File>Send Feedback. Your feedback will promote them to improve the feature in Excel!

Thanks for your patience and understanding!

Best Regards,

Clark