Share via

Timezone formatting problems

Anonymous
2025-01-19T11:19:40+00:00

Hi all,

When typing ctrl + shift+ ; for a timestamp, it comes up with 01/01/1900. My computer timezone is correctly set to London GMT, but is not synching with Excel. Any guesses?

Thank you.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-19T12:39:12+00:00

    Hi Jake_201,

    Thanks for visiting Microsoft Community.

    In Excel, Ctrl + Shift + ; inserts the time in 24-hour format (the date is defaulted to January 1, 1900). While Ctrl + ; inserts the current date (the time is defaulted to 0:00).

    If you need to obtain both, you can use these two shortcuts in sequence within a single cell, or you can use the NOW function like =NOW().

    Hope this helps you confirm the situation.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments