@ sign causes e-mail link

  • Thread starter Thread starter Sandy M
  • Start date Start date
S

Sandy M

We have some worksheets which were created with Excel 97
in which units are entered in the format, eg. 1@350.

If you return to one of these cells to modify if by
left-clicking the cell, it automatically assumes that
you want to send an e-mail to 1@350. You can right-
the cell ahead of time and take off the formatting of
underlining and the blue font, but it is a pain.

Can you tell me if there is somewhere in formatting
where we can disable this from happening?

Thanks,

Sandy M
 
Hi sandy!

Use:
Tools > AutoCorrect Options
AutoFormat as you type Tab
Remove check from "Internet and network paths with hyperlinks"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Added in xl2002 (IIRC).



Norman said:
Hi sandy!

Use:
Tools > AutoCorrect Options
AutoFormat as you type Tab
Remove check from "Internet and network paths with hyperlinks"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Back
Top