EXCEL
Month, Days and Years
To
display months, days, and years, include the following format codes:
| To display |
Use this code |
| Months as 1-12 |
m |
| Months as 01-12 |
mm |
| Months as Jan-Dec |
mmm |
| Months as January-December |
mmmm |
Months as the first letter of the month
(January, June and July all appear as J) |
mmmmm |
| Days as 1-31 |
d |
| Days as 01-31 |
dd |
| Days as Sun-Sat |
ddd |
| Days as Sunday-Saturday |
dddd |
| Years as 00-99 |
yy |
| Years as 1900-9999 |
yyyy |
The example below shows the use of custom format to
format 1/1/2000 as the date in full including the weekday.
Click here to
return to the Excel index.
webmaster@allaboutoffice.co.uk |
