View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I enter an email address w/in a cell & it not be automatic

ToolsAutocorrect OptionsAutoformat as you type.

Uncheck the first "replace as you type" option.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 19:51:00 -0700, smhoff
wrote:

I am using Xcell 2003. When I enter an email address within a cell it
automatically sets it up so that when you click on the cell it automatically
assumes you want to send that email address a message and outlook opens up.
Is there a way to turn this feature off as I want to display a list of email
addresses for a group of people on this spreadsheet however I don't want the
viewer to get discouraged everytime they click on the email address and
having outlook open. If that user doesn't want to email that person, they
then have to close outlook to get back to the spreadsheet and hope they use
the arrow keys in lieu of clicking on the cell.