Excel Data Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1358519%22%20slang%3D%22en-US%22%3EExcel%20Data%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1358519%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20type%20a%20date%20in%20Excel%20(e.g.%2C%205%2F31)%2C%20the%20desktop%20version%20knows%20that%20I%20mean%205%2F31%2F20.%20However%2C%20the%20SharePoint%20version%20thinks%20I%20mean%205%2F1%2F31.%20Does%20anyone%20know%20how%20to%20change%20the%20SharePoint%20version%20so%20that%20it%20behaves%20like%20the%20desktop%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1358519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

When I type a date in Excel (e.g., 5/31), the desktop version knows that I mean 5/31/20. However, the SharePoint version thinks I mean 5/1/31. Does anyone know how to change the SharePoint version so that it behaves like the desktop version?

3 Replies
Highlighted

@kwilliams3344 

Check regional settings for Sharepoint site and/or Onedrive and make them the same as for the desktop.

Highlighted

@Sergei Baklan Thank you so much! I knew it had something to do with non-US settings, but I had no idea how to change it. It works perfectly now!

Highlighted

@kwilliams3344 , you are welcome