how to put an internet-address in Excel just as a text-field?

When I make a table in Excel, I have one column for web-addresses. These
become links that I get connected to every time I try to copy the content of
the fields, but I just want it to be a text-field. How do I disconnect the
automatic link-function?
Thank you.

type a ' (single quote) before http://

HTH
--
AP

"Tomas Barth" <Tomas [email protected]> a écrit dans le
message de news: [email protected]...
> When I make a table in Excel, I have one column for web-addresses. These
> become links that I get connected to every time I try to copy the content
> of
> the fields, but I just want it to be a text-field. How do I disconnect the
> automatic link-function?
> Thank you.

Right-click the hyperlink you want to deactivate, point to Hyperlink on
the shortcut menu, and then click the last item > Remove Hyperlink.


Tomas Barth wrote:
> When I make a table in Excel, I have one column for web-addresses. These
> become links that I get connected to every time I try to copy the content of
> the fields, but I just want it to be a text-field. How do I disconnect the
> automatic link-function?
> Thank you.

Hi Tomas

In 2002 and up you can change this

Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start with a '

You can run this macro also to make text of all hyperlinks
in your worksheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tomas Barth" <Tomas [email protected]> wrote in message news:[email protected]...
> When I make a table in Excel, I have one column for web-addresses. These
> become links that I get connected to every time I try to copy the content of
> the fields, but I just want it to be a text-field. How do I disconnect the
> automatic link-function?
> Thank you.