Why not just apply the *appropriate* Date formatting to the cell?

Just curious |:>)

"Ibbits" wrote:

> So, when I want a date to display as, say, 7/15 and the over aggressive
> autoformat kicks in, I change the cell format to Text, which is supposed to
> 'displays exactly as typed.'
>
> Bingo, perfect. But then when I type in "7/15" I still get a formula error
> message.
>
> That's stupid. Make it stop.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc