Thread: @ sign not to be treated as an email address
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default @ sign not to be treated as an email address
In Excel 2007 :

Office buttton
Excel options
Proofing
Autocorrect options
Autoformat as you type tab


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
In Excel 2002 and up you can disable this

ToolsAutoCorrect options
See the autoformat as you type tab

You can also start with a ' when you start typing
Or use Ctrl z after you enter


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"phmanatee" wrote in message ...
I'm using the @ sign and Excel insists on treating it as an email address,
when I don't want it to. How can I turn this off?
Reply With QuoteReply With Quote