Date Time format changes after saving

Kirby Baxter 0 Reputation points
2023-03-17T12:43:59.01+00:00

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.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,796 Reputation points
    2023-03-20T08:44:52.5+00:00

    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.

    Capture47

    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.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.