Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


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