Shut off email address from linking to email program?

J

Java Jake

Whenever I type in an email address it seems to create a link to my email
site. I don't want a link , I just want the address for reference. Can I shut
this feature off?
 
P

Peo Sjoblom

Precede the entry with an apostrophe, or type them in, then copy an empty cell,
select the email address (obviosuly by using the arrow keys and shift since
you don't want to start your email program), then do edit>paste special and
select add

Regards,

Peo Sjoblom
 
F

Frank Kabel

Hi
with Excel 2002 (or Excel 2003) goto 'Tools - autocorrection' and turn this
feature off
 
J

Java Jake

Frank

Thanks for your quick reply. However, I went to "Tools - autocorrection" (I
have Excel 2003) and could not find anything to turn off resembling that
feature. Meanwhile, another reply suggested using the apostophe in front of
the email address, which works, but I'd like to eliminate the feature. Thanks
again.

Jake
 
F

Frank Kabel

Hi
in this dialog click on the second tab ('Autoformat as you type') and
uncheck 'Internet and network paths....'
 
M

motutapu1

Thanks

That worked. I only wish that there was an "on-off" function that would not
make those steps necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top