View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.setup
Agg
 
Posts: n/a
Default Excel 2000 should not hyperlink automaticly

Hi Sam
If you just want (10@250) in a cell, just force it to text by putting a
single quote in front of it like this ('10@250). Excel won't display the
quote so you will see (10@250) in the cell without the hyperlink. You can
use the same trick to type numbers with leading zeros such as postcodes or
product numbers in cells. If you type (0186) it will generally display as
(186) unless you do some special formatting. But if you type('0186) it will
display correctly as (0186).
Type ('www.microsoft.com) and it will show the URL without creating the
hyperlink.
In these examples, the brackets just indicate the cell - don't type them.

"Sam Rothstein" wrote:

Excel 2000 automaticly hyperlinks, and I can't turn it off. I despise this
"feature" more than Clippy himself. I am not a "newbie" and I DON'T want my
spreadsheets to do things for me without asking. At the least, it should be
something I can turn off.

I get stuck manually undoing every hyperlink that is instead a quantity I'm
shipping (eg: 10@250). It aggrivates me daily. Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup