AnsweredAssumed Answered

Can the @ symbol be turned off

Question asked by Dan Miel on Jul 21, 2008
Latest reply on Jul 24, 2008 by Eddie Cyganik

Like • Show 0 Likes0
Comment • 8

I'm just starting to use the design tables and when I make a change on the part number the next I click on the cell Outlook starts. I end up having to hold the cursor on the cell then right click and remove the hyperlink. Is there a way to turn the hyperlink off for the entire sheet permanently?
Dan Miel
2008 SP4

No one else has this question

Outcomes

8 Replies

Don Eva Jul 21, 2008 7:37 PM
Mark Correct
Correct Answer
It's an Excel function, where it automatically creates a hyperlink when it sees the @ symbol. I'm pretty sure I found the option once in Excel to turn it off, but just looked and couldn't find it. Anyone?

Don
Like • Show 0 Likes0
Actions
- Deepak Gupta @ Don Eva on Jul 21, 2008 7:57 PM
  Mark Correct
  Correct Answer
  Just add ' before writing anything that has @ and you will not get any hyperlink.
  
  For eg. abc@xyz.com so after adding ', it should be 'abc@xyz.com
  Like • Show 0 Likes0
  Actions
Kelvin Lamport Jul 22, 2008 12:45 AM
Mark Correct
Correct Answer
To disable the auto-hyperlink function, when in Excel go to Tools > AutoCorrect Options > AutoFormat As You Type and clear the Internet and network paths with hyperlinks option.
Like • Show 0 Likes0
Actions
- Jennifer Bahnsen @ Kelvin Lamport on Jul 22, 2008 1:27 PM
  Mark Correct
  Correct Answer
  Thank you! Thank you! Thank you! That has been so annoying.
  Like • Show 0 Likes0
  Actions
- Dan Miel @ Kelvin Lamport on Jul 22, 2008 3:10 PM
  Mark Correct
  Correct Answer
  Thanks guys. The quote symbol helped but being able to turn it off completely is really nice.
  Dan Miel
  Like • Show 0 Likes0
  Actions
  - Charles Culp @ Dan Miel on Jul 22, 2008 3:29 PM
    Mark Correct
    Correct Answer
    
    http://www.j-walk.com/ss/excel/usertips/tip031.htm
    If you use Excel 2000, you're out of luck. There is no way to turn this potentially annoying feature off. But you can, however, override it. If Excel creates a hyperlink from your cell entry, click the Undo button (or press Ctrl-Z) to restore the cell's contents to normal text. Or, you can precede the cell entry with an apostrophe.l
    
    So if your company uses 8 year old software, like mine, you are out of luck.
    Like • Show 0 Likes0
    Actions
    - Svetlana Antiperovitch @ Charles Culp on Jul 22, 2008 3:43 PM
      Mark Correct
      Correct Answer
      
      Charles Culp wrote:
      
      http://www.j-walk.com/ss/excel/usertips/tip031.htm
      
      If you use Excel 2000, you're out of luck. There is no way to turn this potentially annoying feature off. But you can, however, override it. If Excel creates a hyperlink from your cell entry, click the Undo button (or press Ctrl-Z) to restore the cell's contents to normal text. Or, you can precede the cell entry with an apostrophe.l
      
      So if your company uses 8 year old software, like mine, you are out of luck.
      
      Mine is 2000 too.
      RMC on the cell. Hyperlink. Remove hyperlink. I use brush button (format painter) to match the rest after I removed one.
      Like • Show 0 Likes0
      Actions
Eddie Cyganik Jul 24, 2008 12:24 PM
Mark Correct
Correct Answer
Dan & All,

Great suggestions/solutions from everyone. Here is another:

Type in any required dimension, such as: Width@Sketch4

The information is in the cell but is not transformed into a hyperlink until the "enter" key is pressed. So, right after the information is entered and turns blue, just hit "Ctrl Z". The undo undoes the last command or the formatting of data to a hyperlink.

My2¢
Like • Show 0 Likes0
Actions

Can the @ symbol be turned off

Outcomes

Related Content

Recommended Content