When I type in an e-mail address into a field, Excel formats it
by changing it into a mailto: link which not only changes the
color of the font, but underlines the text in the field. I would
like just plain text. I looked under Tools -> Auto-Correct Options
but wasn't able to find anything. Where is this switch hidden?

Thanks

Michael




--
/"Careful. We don't want to learn from this."/ -- Calvin

start with a leading apostrophe (')
or pre-format the cell(s) as Text
Bob Umlas
Excel MVP

"Michael" <mailbox30308-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I type in an e-mail address into a field, Excel formats it
> by changing it into a mailto: link which not only changes the
> color of the font, but underlines the text in the field. I would
> like just plain text. I looked under Tools -> Auto-Correct Options
> but wasn't able to find anything. Where is this switch hidden?
>
> Thanks
>
> Michael
>
>
>
>
> --
> /"Careful. We don't want to learn from this."/ -- Calvin