Formatting email addresses

[P D Sterling]

I keep several spread sheets of club membership, etc, and need to
concentrate email addresses, but I do not want them to be hyperlinks. I
have formatted the entire column as Text, but sometimes when I add a
line, the formatting rebounds to some sort of default. I never want any
hyperlinks in my worksheets EVER. Can someone please advise? TIA!!
--

Regards,

P D Sterling
Dallas TX

 

[Guest]

Try this:

From the Excel main menu:
<tools><options><spelling tab>
Click the [AutoCorrect Options...] button
Select the AutFormat as you Type tab
UNcheck: Internet and network paths with hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[P D Sterling]

you the man, Ron - takk so mycket, as they say in the old country

Regards,

P D Sterling
Dallas TX

Try this:

From the Excel main menu:
<tools><options><spelling tab>
Click the [AutoCorrect Options...] button
Select the AutFormat as you Type tab
UNcheck: Internet and network paths with hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP

I keep several spread sheets of club membership, etc, and need to
concentrate email addresses, but I do not want them to be hyperlinks. I
have formatted the entire column as Text, but sometimes when I add a
line, the formatting rebounds to some sort of default. I never want any
hyperlinks in my worksheets EVER. Can someone please advise? TIA!!
--

Regards,

P D Sterling
Dallas TX