Home

Excel 365 date format error

%3CLINGO-SUB%20id%3D%22lingo-sub-855942%22%20slang%3D%22en-US%22%3EExcel%20365%20date%20format%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855942%22%20slang%3D%22en-US%22%3EI%20can%E2%80%99t%20understand%20whats%20happening%20with%20these%20dates.%20I%20formatted%20the%20sheet%20to%20Australian%20yet%20every%20date%20entered%20is%20displaying%20differently%2C%20mostly%20US%20format.%20I%E2%80%99ve%20opened%20new%20tabs%20and%20repeated%20to%20no%20avail.%20Can%E2%80%99t%20seem%20to%20attach%20a%20pic%20here%20to%20show.%20What%20do%20I%20need%20to%20do%20to%20fix%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-855942%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
lsmitchell
Occasional Visitor
I can’t understand whats happening with these dates. I formatted the sheet to Australian yet every date entered is displaying differently, mostly US format. I’ve opened new tabs and repeated to no avail. Can’t seem to attach a pic here to show. What do I need to do to fix?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies