Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 06, 12:19 AM posted to microsoft.public.excel.newusers
JohnnyJomp
 
Posts: n/a
Default 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

  #2   Report Post  
Old January 31st 06, 12:35 AM posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default 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

  #3   Report Post  
Old January 31st 06, 01:09 AM posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default 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



  #4   Report Post  
Old January 31st 06, 04:58 AM posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default 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





  #5   Report Post  
Old January 31st 06, 05:32 AM posted to microsoft.public.excel.newusers
JohnnyJomp
 
Posts: n/a
Default 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



  #6   Report Post  
Old January 31st 06, 05:43 PM posted to microsoft.public.excel.newusers
Ron de Bruin
 
Posts: n/a
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017