It IS preformatted to text, and still complains - that's the point of the post.

"Gord Dibben" wrote:

Try '7/15

OR pre-format the cells to Text.


Gord Dibben Excel MVP


On Thu, 14 Jul 2005 10:48:02 -0700, 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