Excel has a total of sixteen date formatting styles all of which can be found by right clicking the cell that the date is in and selecting Format Cells from the menu and clicking Date in the Categories. A short date and long date shortcut are also located in the Home Tab, in the Number Formatting Box they can be selected from the drop-down menu.
Also, by selecting the bottom right hand corner of the Number Formatting Box (highlighted) the Format
Cells dialog box will appear.
A custom date format allows users to display a date anyway they want.
16 Styles of Date Formatting
- Day of the week, Month, Days, Year
- Monday, January 1, 2018
- Numerical Month / Days
- Numerical Month / Days / Two-digit Year
- Two-Digit Numerical Month / Two-digit Days / Two-digit Year
- Days – Abbreviated Month
- Days – Abbreviated Month – Two-digit Year
- Two-digit Days – Abbreviated Month – Two-digit Year
- Abbreviated Month – Two-digit Year
- Month – Two-digit Year
- Month Days , Year
- January 1, 2018
- Numerical Month / Days / Two-digit Year Time
- 1/1/18 12:00 AM
- Numerical Month / Days / Two-digit Year Military Time
- 1/1/18 0:00
- Initial Month
- Initial Month – Two-digit Year
- Numerical Month / Days / Year
- Days – Abbreviated Month – Year
To change the default date format, open the computer’s Control Panel. Under Clock, Language and Region, select change date, time and number formats. In this window, you can select the formatting for Short Date, Long Date, Short Time, Long Time and change the First Day of the Week. At the bottom, you can view the Examples of what will be displayed based on your formatting selections.
You can create custom date formats within Excel by first selecting the cell you want to format and opening the format cells window.
Select Date from the Category Menu and chose the date format that most closely resembles the format you are creating.
Now select Custom from the Category Menu and you will be …