I think that when you include the year (even if it is only 2 digits) it will use Windows' short date format

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kruppy" wrote in message ...
| When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
| short date regional setting in windows is 11/22/07. When I go to change the
| date format the format that is highlighted is Custom dd-mmm. Any idea
| where this comes from and how I can change it.