Hi. I was wondering how to turn off the autoformatting of dates within Excel
2007. For instance, when you type "3-21", it changes it to "21-Mar."

I know that you can change the formatting of the cell to be "text" before
you type into the cell, or you can add an apostrophe before the text to
indicate that the numbers are text. That's not what I'm asking. I want a
PERMANENT solution to this problem. I find this feature of Excel to be
thoroughly obnoxious (particularly when importing .txt or .csv files), and
I'd like to permanently turn it off. Is there anyway to do this?