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
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.Excel for web keeps its regional setting on SharePoint/OneDrive where files are kept. Thus you have the same if you open it in any browser from any device.
Desktop version takes your PC/laptop setting, that's the only device such Excel knows about.
Desktop - I've done this and it is not working. No reaction and no change. If I choose any formatting, but not change at all.
Browser - I've changed it and it works. In Desktop it is not reflected.
?
Desktop - please try to re-enter the value into the cell (F2->Enter)
Regional setting on web and desktop are not linked.
