Short date displays months and days as either single or double digits and years as double ... If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.

To change the date format in Excel 365, select the cell in your spreadsheet and go to Format > Format Cells. You can find this option in the Home tab. Then, switch to the Date tab and select a ...