Forum Discussion
Solved
Excel 365 online, Formatted as dates, but displayed as numbers?
My group has been using a shared excel work book for over a year and around the start on 2021 a new "bug?" has developed. Our sheet has several columns that are formatted as dates. When we ope...
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.
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.