In Excel 2002, dates entered in a worksheet as "dd/mm" default to a custom
format of "d-mmm". For example, 4/26 shows as 26-Apr in the worksheet cell
even though it is shown as 4/26/2005 in the Formula Bar. I want them to
default to "mm/dd/yyyy". In the Regional settings, the default short date
format is shown as "dd/mm/yyyy".

Any ideas?