Yeah, that would be ideal, but the format i need to use isn't an option: 7/15
as July 15. My boss uses excel to track projects. The spreadsheets can become
massive, so the m/dd format works best because it's compact. (these often
get pasted [as pictures] into ppt for distribution to clients, so size does
matter)

I like the idea of using "\" ... but (and yes, this is pathetic), the
engineers who make up the audience for the ppt's are incredibly
obsessive/compulsive about consistency, and if the dates in the e-mail or
other documents that accompany the schedules look different (either by using
dashes, alternate formats or back slashes in place of front slashes), the
meetings for which these materials are created get de-railed
by these brilliant morons' obsession with finding "nits" - and then it
becomes a competition to see who can find the most nits - and then the
chairman spends the rest of the meeting trying to keep the fellas focused on
the topic. I really wish I was exaggerating.


"CyberTaz" wrote:

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