Ugh, ever enter an email address or URL into Excel then have to click on the cell? It always makes the text into a link, and launches a browser or Outlook! Here is how to disable them!
Here's how you can turn off this activation so that your URLs remain as regular text. (This tip works with Microsoft Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
Click Proofing at the left of the dialog box.
Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box.
Make sure the AutoFormat As You Type tab is selected. (Click here to see a related figure.)
Clear the Internet and Network Paths With Hyperlinks check box.
Click OK.
The steps to follow are different if you are using Excel 2002 or Excel 2003:
Choose AutoCorrect Functions from the Tools menu. Excel displays the AutoCorrect dialog box.
Make sure the AutoFormat As You Type tab is selected.
Clear the Internet and Network Paths With Hyperlinks check box.
Click OK.
using Excel 2000, your options are severely limited—Excel doesn't allow you to turn off the conversions