» Customizing Date Formatting in Excel 2007

To customize the date formatting:

1. Select cell A1 in the sheet, and insert the current date by pressing Ctrl+;.
2. Select Home -> Number Format dropdown list (in Number Group) -> Short Date or Long Date
Or press Ctrl+1, select the Number tab, and then select Custom.
3. Clear the Type box.
4. Enter the date format in the Type box, based on to the list of symbols below:
m (Month): Displays the months number, without a leading 0 if the number is lower than 10.
mm (Month): Displays the months number, including a leading 0 if the number is lower than 10.
mmm (Month): Displays the first three characters of the months name.
mmmm (Month): Displays the months full name.
mmmmm (Month): Displays the first character of the months name.
d (Day): Displays the days number, without a leading 0 if the number is lower than 10.
dd (Day): Displays the days number, including a leading 0 if the number is lower than 10.
ddd (Day): Displays the days name as a three character text.
dddd (Day): Displays the days full name.
yy or y (Year): Displays the last two digits of the year.
yyy or yyyy (Year): Displays the full year.