Microsoft Excel date issue-working with multiple PC by multiple people

ram kumar 1 Reputation point
2022-11-01T11:27:21.687+00:00

Hi Team,

I was working on one of the worksheet which was worked by another person. His PC had date format in dd-mm-yy format.
The sheet had Monthly date with time. My PC had date format in mm-dd-yy format.

When I started using the sheet the month showed changed to day from the sheet used by the another person. The sheet had formula using the DATE function with addition of months to date, which has not working properly in my system due to the date format change. Is there a possible way to freeze the date irrespective of the individual PC format.

Thank you
Regards,
RAMKUMAR

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,671 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,556 Reputation points
    2022-11-02T05:26:36.803+00:00

    Hi @ram kumar

    > Is there a possible way to freeze the date irrespective of the individual PC format.

    Sorry for the inconvenience, but we are unable to fulfill your needs at this time. Excel's date format is affected by, for example, Windows Region settings,.

    Please try to change the date format to the one used in your part of the world.
    256265-capture1.png

    If it does not work, I would suggest you change your Windows Region settings,
    256207-capture2.png

    Thanks for your understandings.


    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.