Email address

L

Les

I have a spreadsheet with a particular cell in which I only want to record email address. However, whenever I type an address in there and hit Enter it tries to connect to Outlook. How can I format this cell so that it does not try to connect to the internet?
 
R

Ron de Bruin

Hi Les

In 2002/2003 you can turn it of

Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

Or if you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start the cell with a '
Excel see it as text then


--
Regards Ron de Bruin
http://www.rondebruin.nl


Les said:
I have a spreadsheet with a particular cell in which I only want to record email address. However, whenever I type an address in
Click to expand...
there and hit Enter it tries to connect to Outlook. How can I format this cell so that it does not try to connect to the internet?
 

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

Have 4 email addresses Want to auto forward all in one of them 0
Outlook - Catgorizing emails by names 0
Can't send emails but can receive in Outlook 2019 1
Blocking junk email 0
Merging from an Excel file with graphics 1
A couple questions BEFORE using Office 365 0
Excel does not accept text format! 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top