Date Time format changes after saving

Question

Hey All,

I am needing an excel file to save my date in the following format dd:mm:yyyy hh:mm:ss. When I change the column to that format using "custom" it shows in the column correctly and in the formula. However, when I save the document and reopen it, the date in the column has changed to dd:mm:yyyy hh:mm, but the date in the formula bar remains correct. While trying to find this solution, I saw where I needed to change my regional date/time settings. I have changed them to match the needed format. How do I make the date/time stay the format I want?

Thank you for any help you can provide.

Answer 1

Hi @Kirby Baxter

Could you please tell us the format the workbook saved to be?

If it is .csv, I would suggest you try .xlsx to have a check.

And what regional date/time settings that you set?

Please take a screenshot of the Region settings in Control Panel, like the following image.

Besides, it's recommended to use Text formula, such as =TEXT(A1,"dd:mm:yyyy hh:mm:ss") if you can use formula.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---