View Single Post
  #5   Report Post  
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