Try '7/15

OR pre-format the cells to Text.


Gord Dibben Excel MVP


On Thu, 14 Jul 2005 10:48:02 -0700, Ibbits <Ibbits@discussions.microsoft.com>
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