Fonts for E-Mail Addresses
 

Whenever I type in excel, if I type an e-mail address, it
always goes to color blue, underlined and 5.5 font. I
typically want it to be black, bold and 13 font. How can
I change it to default to this? Thank you.

Fonts for E-Mail Addresses
 

Hi Susan

In Excel 2002 you can turn it of

ToolsAuto correct Options
See the <AutoFormat as You Type Tab

For older versions:
If you type in a E-mail address you can press Ctrl-Z after you
press enter to make it text

To make text from all your hyperlinks use a macro like this

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
InsertModule from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"susan" wrote in message ...
Whenever I type in excel, if I type an e-mail address, it
always goes to color blue, underlined and 5.5 font. I
typically want it to be black, bold and 13 font. How can
I change it to default to this? Thank you.