Formatting email addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P D Sterling - 30 Aug 2006 19:12 GMT

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!!

Signature

Regards,

P D Sterling
Dallas TX

Reply to this Message

Ron Coderre - 30 Aug 2006 19:19 GMT

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!!

Reply to this Message

P D Sterling - 30 Aug 2006 22:14 GMT

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

Regards,

P D Sterling
Dallas TX

> Try this:
>
[quoted text clipped - 16 lines]
>> line, the formatting rebounds to some sort of default. I never want any
>> hyperlinks in my worksheets EVER. Can someone please advise? TIA!!

Reply to this Message