In Excel: How do I turn off automatic e-mail if text has @ sign?

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I turn off the automatic text suggestion in excel? 2
how do I turn off an Automatic Scientific Format 2
how do you turn off automatic hyperlink in excel 2003 1
how do I turn off the automatic opening of my next e-mail in my in 3
How do I permanently deactivate auto e-mail in Excel? 2
How do I turn off the text to speech facility in Exccel? 1
How do I stop e-mail address from turning into link in Excel? 3
How do I turn off e-mail conversion to a name instead of address 1

Top