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
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.
SergeiBaklan I have tried this on desktop however I am still getting the number displaying as my date rather than the date itself. My cell is formatted as short date on the desktop. I changed the Regional Settings on the Web version and that displays correctly. Not sure what else to do now. Can you help? Thanks.
