Forum Discussion
Ian Williams
Feb 11, 2017Copper Contributor
Excel 365 online, date formatting problem.
Dear all, I have a problem with date formatting, I think it is a bug in the program but I'm not sure. When editing in Excel proper, in the attached file there is a formula in column A which reads d...
ebbenjay
Jul 19, 2019Copper Contributor
Hey Ian Williams,
I believe I solved the issue. After checking my computer and OneDrive regional settings and confirming they were correct, I also thought to check my SharePoint regional settings.
I opened the SharePoint location where my Excel document was stored and went to regional settings and found it set to somewhere in south America.
After correcting this the issue was resolved.