ExcelBanter - View Single Post

Ken Hutchinson

Wrote:
Steve wrote:
Presumably firing your boss is not an option?

You could try preceding your parts numbers with an apostrophe (e.g.
'2404-08-12) to let Excel know that it's dealing with text.

Thanks for the suggestion, Steve. I've actually considered somethine
like this, but honestly I don't think he's going to accept any solution
that requires an effort on his part. He's one of the people who has
little patience or understanding of technology. He just expects it to
work, no matter how many times it's his fault. Needless to say, this
makes my job difficult since I'm the one he calls into his office to
fix something he screwed up every time he works in Excel. You can only
imagine what happens when he tries to do a date sort.

--
Ken Hutchinson
------------------------------------------------------------------------
Ken Hutchinson's Profile: http://www.excelforum.com/member.php...o&userid=36888
View this thread: http://www.excelforum.com/showthread...hreadid=566058