Fields that contain e-mail addresses

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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
 
start with a leading apostrophe (')
or pre-format the cell(s) as Text
Bob Umlas
Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

E-mails "converted to plain text" 3
Passing variable to the To field 1
Font enlarges when cell is linked to email 6
Sky e-mail via outlook 2
Reverse Hyperlink - change mailto to text 3
e-mail field 3
E-mail addresses mysteriously unresolved themselves... 6
Text Box with Font, Size & Color options 1

Back
Top