Excel 2007: Most online docs claim that Excel's default date settings are
controlled by the Regional and Language Settings (Windows XP) in the
I have my short date format set to MM/dd/yyyy.
What I don't like, is that when I leave out the year, and enter something
like 1/15 in a cell (which didn't previously have any formatting) in Excel
2007, it gets formatted as dd-mmm and shows as "15-Jan". (The full date
01/15/2008 correctly shows in the Formula bar.)
I don't *ever* want Excel to show "15-Jan". I *hate* that format. I would
like to banish it from Excel's knowledge forever. But, I can't delete that
Is there any way to tell Excel that the default date format for all numbers
that look like dates is "MM/dd/yyyy", regardless of how they are entered,
with or without the year?
(The Long date format in the Regional Settings control panel is "dddd, MMMM
dd, yyyy", or "Tuesday, January 15, 2008" so that's not what's being used
I don't see this issue discussed anywhere.