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
On desktop you shall apply Date format to the cells.
On Excel for web to change regional settings in File->Settings
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.
Fabrice0966 Do you numbers on Desktop or on Web?
