Re: turn off hyperlink

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <mjensen-8B0560.17361512042007@xxxxxxxxxxxxxxxxxxxx>,
John <mjensen@xxxxxxxxxxxx> wrote:

People,
I'm using Office 2004 on an eMac running OS 10.2.8. I have a simple
spread*** of people's names and addresses. I wanted to also include
their e-mail addresses so I started typing that info into a new column.
However as soon as I typed it in, Excel underlined it and wanted to
treat it as a link to my Mail application. I finally figured out how to
delete the hyperlink for each entry but isn't there a global setting
somewhere that I can uncheck so Excel doesn't automatically set up an
e-mail hyperlink every time I enter text that "looks" like an e-mail
address?

John

People,
My thanks to all of you for responding. This looks like one of those
cases where the application software has been overdesigned. That is, it
has gone too far in anticipating what the user wants to do. Not
everybody wants "fries with their hamburger" but the prevailing approach
is to include the "fries" as part of the package. Too bad.

At any rate, I love VBA but I am an infrequent Excel user so I don't
think I want to go that route just to solve this little irritant. I did
like two of the simpler approaches. Adding an apostrophe at the
beginning is very acceptable. I also tried the Edit/Copy/Paste Special
but as Daiya pointed out, it only works when the data is pasted to a new
column.

Thanks again - problem solved.

John
Project MVP
.

Quantcast