Group:  Microsoft Excel ยป microsoft.public.excel
Thread: Formatting email addresses

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Formatting email addresses
P D Sterling <pdsterling[ at ]hotmail.com> 30.08.2006 18:12:46
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
RE: Formatting email addresses
Ron Coderre 30.08.2006 18:19:01
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" wrote:

[Quoted Text]
> 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
>
Re: Formatting email addresses
P D Sterling <pdsterling[ at ]hotmail.com> 30.08.2006 21:14:20
you the man, Ron - takk so mycket, as they say in the old country

Regards,

P D Sterling
Dallas TX


Ron Coderre wrote:
[Quoted Text]
> 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" wrote:
>
>> 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
>>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net