Forum Discussion
Excel 365 online, Formatted as dates, but displayed as numbers?
On desktop you shall apply Date format to the cells.
On Excel for web to change regional settings in File->Settings
I see second post today about this bug, but can't reproduce. Is that only when more than one person works with the file?
In any case I'd Send a Frown from Help->Feedback.
SergeiBaklan Thank you!
This is a shared document and the problem is only present when opened in the browser.
It may help to know that these cells are within a table on the sheet, (with data validation parameter for these dates).
For example, the selected cell in column "H" is formatted as 'Date' and while the formula bar displays the date as "12/11/2020", the cell it's self displays "44176".
Note: We have recently increased the number of people using the sheet form 5 to 12. I'm considered that someone may have accidentally made a change that that has caused this problem, but I am flummoxed on what it could be.
Hello, I have the same issue, but the problem is visible only in desktop Excel. The cells contain a date (like 28.5.2021) but it is show a number instead (for example 44451). When I open this document in a browser (Chrome), the dates are show in a different format (DD/MM/YYYY) but at least it is readable.
No change of format helped. Where is the problem? Any ideas why is this happening?
Thanks!
On desktop you shall apply Date format to the cells.
On Excel for web to change regional settings in File->Settings
- Thank you!
I was not aware that 365 had it's own "Languiage and Region" settinges. While (for me) this issue had resolved it's self by March 2021, I now have entered my prefered "Regional format" for the dates and times.
