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.
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 ...