About Us

Scoops

Ken Hutchinson wrote:
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.

Hi Ken

Hmm, I think you may be stuck with this. Excel is trying to be helpful
and in your case it really is a pain. I don't know of a global setting
that you can change so, even if you're setting the cells to text, the
next time he opens a new sheet the same "problem" will be presented.

The only real solution I can think of is to change the parts numbers to
something not resembling dates (e.g replace the hyphen with a comma or
add leading zeros - 02404-008-012). How realistic a solution that is
I'll leave to you.

Regards

Steve

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stop date conversion in Excel when pasting	Stephanie	Excel Discussion (Misc queries)	4	February 20th 11 07:58 PM
date conversion after pasting	DC Gringo	Excel Worksheet Functions	2	February 16th 06 06:05 PM
Showing todays date when the Excel value is zero	David Hall	Excel Worksheet Functions	1	January 7th 06 05:19 PM
Date conversion issue "^" symbol	Shannon	Excel Discussion (Misc queries)	1	May 4th 05 12:25 AM
unwanted number to date conversion while pasting data from web	Jacek	Excel Worksheet Functions	1	February 24th 05 02:59 PM