Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel: How do I turn off automatic e-mail if text has @ sign?
I am writing spreadsheet that requires users to enter stock-symbol
tickers, which for various reasons *must be typed in like this: F@US (Ford, on US stock exchanges; MSFT@US for Microsoft, etc.) Everytime I enter this text in a cell, Excel sees the ampersand, thinks it's an e-mail address and tries to link to Outlook. I can't find a way to turn this function off. Any help out there? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel: How do I turn off automatic e-mail if text has @ sign?
I think that Excel behavior is caused by the AutoCorrect options
Try this: From the Excel main menu: <tools<options<spelling tab Click the [Autocorrect options] button Select the "Autoformat as you type" tab UNcheck: Internet and network paths with hyperlinks. Does that help? *********** Regards, Ron XL2002, WinXP "kvnexcel" wrote: I am writing spreadsheet that requires users to enter stock-symbol tickers, which for various reasons *must be typed in like this: F@US (Ford, on US stock exchanges; MSFT@US for Microsoft, etc.) Everytime I enter this text in a cell, Excel sees the ampersand, thinks it's an e-mail address and tries to link to Outlook. I can't find a way to turn this function off. Any help out there? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel: How do I turn off automatic e-mail if text has @ sign?
RON -- It worked and I am grateful.
"kvnexcel" wrote: I am writing spreadsheet that requires users to enter stock-symbol tickers, which for various reasons *must be typed in like this: F@US (Ford, on US stock exchanges; MSFT@US for Microsoft, etc.) Everytime I enter this text in a cell, Excel sees the ampersand, thinks it's an e-mail address and tries to link to Outlook. I can't find a way to turn this function off. Any help out there? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Data from Excel to MS Outlook in Plain Text Mode | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |