Formatting email and web addresses in Excel

Hi all...
I want to put email and web addresses in my worksheets, but I do not want
them to be active links. IOW, they should be just text, not links to emails
or web pages.

I have tried formatting the cells as text and general. I have even put the
web address without the www., but it still reformats it!

Any tips???
Thanks!
JJ

Put a single quote (apostrophe) in front of the address
--
Gary's Student


"JohnnyJomp" wrote:

> Hi all...
> I want to put email and web addresses in my worksheets, but I do not want
> them to be active links. IOW, they should be just text, not links to emails
> or web pages.
>
> I have tried formatting the cells as text and general. I have even put the
> web address without the www., but it still reformats it!
>
> Any tips???
> Thanks!
> JJ

Try one of these options, JJ:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"JohnnyJomp" <[email protected]> wrote in message
news:[email protected]...
> Hi all...
> I want to put email and web addresses in my worksheets, but I do not want
> them to be active links. IOW, they should be just text, not links to
> emails
> or web pages.
>
> I have tried formatting the cells as text and general. I have even put the
> web address without the www., but it still reformats it!
>
> Any tips???
> Thanks!
> JJ

not much point to using MS Word to remove links,
when you can use a macro, see
http://groups.google.com/groups?thre...tngp13.phx.gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anne Troy" <[email protected]> wrote in message news:[email protected]...
> Try one of these options, JJ:
> http://www.officearticles.com/excel/...soft_excel.htm
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
>
> "JohnnyJomp" <[email protected]> wrote in message
> news:[email protected]...
> > Hi all...
> > I want to put email and web addresses in my worksheets, but I do not want
> > them to be active links. IOW, they should be just text, not links to
> > emails
> > or web pages.
> >
> > I have tried formatting the cells as text and general. I have even put the
> > web address without the www., but it still reformats it!
> >
> > Any tips???
> > Thanks!
> > JJ
>
>

Thank you Gary's Student!
John

"Gary''s Student" wrote:

> Put a single quote (apostrophe) in front of the address
> --
> Gary's Student
>
>
> "JohnnyJomp" wrote:
>
> > Hi all...
> > I want to put email and web addresses in my worksheets, but I do not want
> > them to be active links. IOW, they should be just text, not links to emails
> > or web pages.
> >
> > I have tried formatting the cells as text and general. I have even put the
> > web address without the www., but it still reformats it!
> >
> > Any tips???
> > Thanks!
> > JJ

Hi JohnnyJomp

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


"JohnnyJomp" <[email protected]> wrote in message news:[email protected]...
> Thank you Gary's Student!
> John
>
> "Gary''s Student" wrote:
>
>> Put a single quote (apostrophe) in front of the address
>> --
>> Gary's Student
>>
>>
>> "JohnnyJomp" wrote:
>>
>> > Hi all...
>> > I want to put email and web addresses in my worksheets, but I do not want
>> > them to be active links. IOW, they should be just text, not links to emails
>> > or web pages.
>> >
>> > I have tried formatting the cells as text and general. I have even put the
>> > web address without the www., but it still reformats it!
>> >
>> > Any tips???
>> > Thanks!
>> > JJ