Short date displays months and days as either single ... 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 ...