Formatting email addresses

  • Thread starter Thread starter P D Sterling
  • Start date Start date
P

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
 
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
 
you the man, Ron - takk so mycket, as they say in the old country

Regards,

P D Sterling
Dallas TX


Ron said:
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 said:
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
 
Back
Top