News

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.