I have a spreadsheet with names, addresses, phone numbers, and e-Mail
addresses.
Is there ANY way to stop Excel 2003 SP2 from automatically turning the
e-Mail addresses into Hyperlinks every dern time I copy the address or in
any other manner make that cell active?

TIA,
Steve

Try putting a single quote in front of the address.

Not the best solution but it is what M$ recommends.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Og" wrote:

> I have a spreadsheet with names, addresses, phone numbers, and e-Mail
> addresses.
> Is there ANY way to stop Excel 2003 SP2 from automatically turning the
> e-Mail addresses into Hyperlinks every dern time I copy the address or in
> any other manner make that cell active?
>
> TIA,
> Steve
>
>
>

Under Tools, select auto correct.
click the auto Correct as You type
Deselect Internet Paths


"Og" wrote:

> I have a spreadsheet with names, addresses, phone numbers, and e-Mail
> addresses.
> Is there ANY way to stop Excel 2003 SP2 from automatically turning the
> e-Mail addresses into Hyperlinks every dern time I copy the address or in
> any other manner make that cell active?
>
> TIA,
> Steve
>
>
>

Joel, thanks for that one I searched some time ago and only found the point
about a single quote.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Joel" wrote:

> Under Tools, select auto correct.
> click the auto Correct as You type
> Deselect Internet Paths
>
>
> "Og" wrote:
>
> > I have a spreadsheet with names, addresses, phone numbers, and e-Mail
> > addresses.
> > Is there ANY way to stop Excel 2003 SP2 from automatically turning the
> > e-Mail addresses into Hyperlinks every dern time I copy the address or in
> > any other manner make that cell active?
> >
> > TIA,
> > Steve
> >
> >
> >

Joel:
That's the ticket !!!
No wonder I couldn't find what I was looking for under Tools | Options
Steve

"Joel" <(E-Mail Removed)> wrote in message
newsB49FBD2-65C9-4496-832B-(E-Mail Removed)...
> Under Tools, select auto correct.
> click the auto Correct as You type
> Deselect Internet Paths
>
>
> "Og" wrote:
>
>> I have a spreadsheet with names, addresses, phone numbers, and e-Mail
>> addresses.
>> Is there ANY way to stop Excel 2003 SP2 from automatically turning the
>> e-Mail addresses into Hyperlinks every dern time I copy the address or in
>> any other manner make that cell active?
>>
>> TIA,
>> Steve
>>
>>
>>