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
Fabrice0966 Could you please attach workbook removing all other information but dates in question?
Fabrice0966 , you are welcome, glad it helped
SergeiBaklan yes that has worked, fantastic. Thank you very much. Greatly appreciated.
Kind regards
Fabrice
Fabrice0966 @Sergei Baklan same on my side. I've downloaded your file, opened in desktop Excel and the dates are "corrupted". When I uploaded them to OneDrive or SharePoint and opened in a web browser (Chrome), everything was ok. See enclosed screenshot.
Really no clue where to search for the solution because this is not happening always. In my case the dates were one day OK, the other day where "corrupted."
- SergeiBaklan well that's interesting. The uploded attachment shows the dates being correctly formatted but on my SharePoint and Desktop it doesn't. Not sure if that can be explained as to what is happening here?
SergeiBaklan I have attached the fields in question. You can see that the dates are formatted as such but only numbers are appearing. Thanks again for your help.
