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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,457 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 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.