View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jknapp1005 jknapp1005 is offline
external usenet poster
 
Posts: 25
Default Using the @ symbol in a cell

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?