how do I prevent @ convertng to email?

  • Thread starter Thread starter GeorgeB
  • Start date Start date
G

GeorgeB

If I enter something that looks like an email address (or perhaps it
is), Excel 2000 turns it blue and into a link.

How can I prevent both the color change and its being turned into a
link? I'm using a template (xlt) and ideally can change it for all
occurentcs, or at least for selected cells in that template.

Thanks!
 
Hit ctrl-z as soon as the conversion takes place.

I think you could start with a leading apostrophe (it works ok in xl2003), too.

'(e-mail address removed)

By the way, there's an option added in xl2002 that lets you turn this off.
 
By the way, there's an option added in xl2002 that lets you turn this off.

Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK
 
Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK
Click to expand...

I've got that capability in Word (back to 97, I think), but not in
Excel 2000. Thanks for filling in the hole, though, as I had looked
and not found; at least now I know it needs a newer version than I
run.

The control-Z works, though.

THANKS, ALL

George
 
Using Ctrl+z (Undo) each time to undo a hyperlink, or preceding an entry with a
single quote each time can really interfere with typing. Formatting cells to text
does not prevent cell from becoming an email hyperlink.

So it may be easier to just let them get created as hyperlinks and then delete
them from a selection using a macro.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks
May be useful to Excel 2002 and above as an easier choice rather than
switching the option off under spell checking, when you want them sometimes
but not at other times.

Sub DelHyperlinks()
Selection.Hyperlinks.Delete
End Sub

A non macro solution: Select an empty cell (never used cell) and copy it (Ctrl+C)
then select the cells or column that you want to remove the hyperlinks from,
then Edit, Paste Special, Add

If not familiar with macros see my getstarted.htm page.
 
Using Ctrl+z (Undo) each time to undo a hyperlink, or preceding an entry with a
single quote each time can really interfere with typing. Formatting cells to text
does not prevent cell from becoming an email hyperlink.

So it may be easier to just let them get created as hyperlinks and then delete
them from a selection using a macro.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks
Click to expand...
If not familiar with macros see my getstarted.htm page.
Click to expand...

Thanks! I have been using computers since CP/M 1.3 days, and until I
tried to use macros in Excel thought I was ok ... it doesn't work like
macros with which I'm accustomed to working. My macro experience is
in text editors.

The ctrl-Z will meet my needs considering that I cannot preformat a
cell in an xlt file to do it, but I will look at your page anyway;
macros are so useful and I don't know how to use them.

George
 
Back
Top