How do I enter an email address w/in a cell & it not be automatic

[Guest]

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.

 

[Gord Dibben]

Tools>Autocorrect Options>Autoformat as you type.

Uncheck the first "replace as you type" option.


Gord Dibben MS Excel MVP

 

[Guest]

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 and hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

that helps when the email address has not already been entered into the cell.
however since the email address was already entered, "unchecking" the box
doesn't work. I tried clearing the cell and typing in a new email address
however it still comes up with the auto mail to feature. do i have to start
over using your original instructions or is there another way to turn it off
although the spreadsheet is already started?

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 and hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP

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.

 

[Guest]

Try this:

Copy a blank cell

Select the range of email addresses

From the Excel main menu:
<edit><paste special>....Check: Add......Click [OK]

That should convert them to regular text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

that helps when the email address has not already been entered into the cell.
however since the email address was already entered, "unchecking" the box
doesn't work. I tried clearing the cell and typing in a new email address
however it still comes up with the auto mail to feature. do i have to start
over using your original instructions or is there another way to turn it off
although the spreadsheet is already started?

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 and hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP

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.

 

[Guest]

Thank You! That works!

Try this:

Copy a blank cell

Select the range of email addresses

From the Excel main menu:
<edit><paste special>....Check: Add......Click [OK]

That should convert them to regular text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

that helps when the email address has not already been entered into the cell.
however since the email address was already entered, "unchecking" the box
doesn't work. I tried clearing the cell and typing in a new email address
however it still comes up with the auto mail to feature. do i have to start
over using your original instructions or is there another way to turn it off
although the spreadsheet is already started?

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 and hyperlinks

Does that help?
***********
Regards,
Ron

XL2002, WinXP


:

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.

 

[Guest]

another simple way is after typing the email address and hitting enter, hit
the undo button once and it deactivates the link, but leaves the text.