Share via

Dateformat difference between Excel Online and Excel app

Anonymous
2020-08-17T06:48:37+00:00

Hello,

There seem to be a difference in how Excel shows a date in Excel online and in the app.

The online versions show the actual date, but the app show random numbers although the cell contains the correct date.

How is this possible?

Excel online:

Excel app:

Microsoft 365 and Office | Excel | For home | 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

Answer accepted by question author

Anonymous
2020-08-19T06:12:51+00:00

Hi Tom,

Thanks for posting back.

Based on our test, if we press CTRL+A to select all data and then CTRL+C to copy and CTRL+V to paste the content to a new workbook, it will work normally at our end.

Hope this method could help you out.

Best Regards,

Sandro

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-21T05:40:49+00:00

    Hi Tom,

    Haven’t heard from you for a while.

    According to my last reply, is there anything unclear with the format cell in your Excel?

    Let us know if it helps.

    Best Regards,

    Sandro

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-08-17T09:57:22+00:00

    Thank you for that info.

    Now I understand that the number is the number of days since 1/1/1990.

    However I can't change the cell settings, it keeps changing the date into the number.

    This is the file:

    https://********-my.sharepoint.com/**************************

    【PII has been masked by MSFT】

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-08-17T09:33:10+00:00

    Hi Tom,

    Welcome to community forum. It’s my pleasure to assist you.

    According to your description, we tested at our end and we couldn’t reproduce this issue. In our test, we type the data as you provided in Excel online and set its format as General and then click open in desktop. We didn’t meet the scenario as you mentioned, it still turns out to be the same as the online version. And both of the formats in online and desktop are General.

    In this way, we would like to confirm with you about the format at your end, or you could also change its format to date. (When we set date as format, we couldn’t reproduce this issue either)

    If the issue still exists after changing the format, would you mind providing the following information to help us narrow down the issue?

    1.Your Office subscription screenshot via File>Account>Product Information. In order to protect your privacy, please help us mask your PII, such as email address.

    1. May we know your cell format on both online and desktop app?
    2. Will this issue only happen to the specific workbook? If so, could you please upload it to OneDrive and then share the link in public? So that we could test at our end and share the test result as soon as possible. Please note that don’t upload files included private content. Reference:

    Upload and save files and folders to OneDrive

    Share OneDrive files and folders

    Wish you have a good day.

    Best Regards,

    Sandro

    Was this answer helpful?

    0 comments