If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date. 4. Excel offers many other date format choices. In the cell format menu, click on "More ...

This is because people often use dates in Excel tables, so the program thinks it's being helpful by saving you the time it ...