View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Using the @ symbol in a cell

go to toolsauto correct optionsautoformat as you type tab and unselect
replace as you type internet and network paths with hyperlink.

this will not remove existing hyperlinks and you can still add a hyperlink
using cell formatting
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"jknapp1005" wrote:

I have a friend at work who was using Excel (2003) and was typing using the @
character for something totally unrelated to an email hyperlink and Excel
turned all of the cells in her spreadsheet using the @ symbol into
hyperlinks. I used replace to get rid of the "@" and turn it into "at", but
it remained a hyperlink. I got rid of the hyperlink by right clicking each
cell and deleting it. Is there someway to get Excel to automatically not
assume you are typing in a hyperlink? Also, I couldn't find a way to choose
all the cells and have the same option of clearing the hyperlink? Any easy
way to do that?