Excel: Prevent Conversion of URLs into Hyperlinks
Excel automatically converts URLs into hyperlinks. This explains how to prevent this from happening.
- Excel, like most office programs, automatically coverts text that appears to be an URL into a hyperlink.
You can prevent this from happening by prefacing the url text with an apostrophe.
http://www.tech-recipes.com will be converted into http://www.tech-recipes.com
‘http://www.tech-recipes.com will be displayed as http://www.tech-recipes.com
If you forget this tip and excel converts your URL to a hyperlink, you can correct this:
[list]Excel 2003
1. Right-click on the URL
2. Select Remove Hyperlink from the menu that appears
Excel Previous Versions
1. Right-click on the URL
2. Select Hyperlink from the menu that appears
3. Left click on Remove Hyperlink





