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

Formatting email and web addresses in Excel
 

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

Formatting email and web addresses in Excel
 

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

"JohnnyJomp" wrote in message
...
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

Formatting email and web addresses in Excel
 

not much point to using MS Word to remove links,
when you can use a macro, see
http://groups.google.com/groups?thre...gp13.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" wrote in message ...
Try one of these options, JJ:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"JohnnyJomp" wrote in message
...
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

Formatting email and web addresses in Excel
 

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

Formatting email and web addresses in Excel
 

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
InsertModule 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" wrote in message ...
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