Excel column formatting for dates - Microsoft Community


excel- formatting dates in column requires enter dd-mm-yy if want mm-dd-yy. there formatting option mm-dd-yy seems nothing. escalated , researched story remains same. have enter dates backward. can't fixed? seems no-brainer.

excel interprets dates entered using system locale settings, not cell format.

if want enter dates in order, change windows locale settings accordingly.

kevin



Office / Excel / Windows 10 / Office 365 Home



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

What is the Office 365 default group Mailbox Users ISV Access Enabled - Microsoft Community