Excel shouldn't bitch about a "date format" when formatted as txt

I

Ibbits

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/com...3-5e051163044a&dg=microsoft.public.excel.misc
 
R

RagDyer

What happens if you prefix it with an apostrophe, instead of actually
formatting the cell as text?
Does that work any better?

Another option ... that I use when entering yarn sizes in formulas:
20/1, 36/1, 2/14
I use the *backslash*:
20\1, 36\1, 2\14

With no calculations involved, it serves it's purpose, without the necessity
of having to use extra keystrokes, or having to pre-format any ranges.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
C

CyberTaz

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

Just curious |:>)
 
I

Ibbits

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.
 
Top