Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2014, 11:55 AM
Ridgerunner Ridgerunner is offline email address formatting in a cell Windows 7 64bit email address formatting in a cell Office 2003
Novice
email address formatting in a cell
 
Join Date: Dec 2011
Posts: 20
Ridgerunner is on a distinguished road
Default email address formatting in a cell

How do I get excel 2003, and 2010 for that matter, to NOT automatically treat an email address typed into a cell as a link? Formatting the call as a number or as text doesn't work - no format seems to work. This is very irritating. Every time you touch a cell with that link it assumes you want to send a message to that address and opens an email program and you have to waste time backing out of everything. This can't be difficult but I sure can't figure it out.
Reply With Quote
  #2  
Old 02-06-2014, 03:42 AM
jamesdann jamesdann is offline email address formatting in a cell Windows 7 32bit email address formatting in a cell Office 2010 32bit
Banned
 
Join Date: Jan 2014
Posts: 26
jamesdann is on a distinguished road
Default

Follow these steps to stop creating hyperlinks for an E-mail address.

In Excel 2010:
- Go to the File menu and click on Options.
- Now click on Proofing in the left column.
- Now click on AutoCorrect Options.
- In the AutoCorrect box, click on AutoFormat As You Type tab.
- Now uncheck the box of Internet and networks paths with hyperlinks.
- Now click on OK twice.

In Excel 2003:
- Click on Tools menu.
- Now click on AutoCorrect Options.
- Now you see Autoformat As You Type tab.
- Now clear the check box of Internet and networks paths with hyperlinks.
- Now click on OK.
Reply With Quote
  #3  
Old 02-06-2014, 12:13 PM
Ridgerunner Ridgerunner is offline email address formatting in a cell Windows 7 64bit email address formatting in a cell Office 2003
Novice
email address formatting in a cell
 
Join Date: Dec 2011
Posts: 20
Ridgerunner is on a distinguished road
Default

Thank you very much. Problem solved 100%. I'm very grateful and have passed the info on to others I know who have had the same issue. I've explored these tools and settings options so I'll know better how to fix other issues that might arise.
Reply With Quote
  #4  
Old 02-06-2014, 07:56 PM
jamesdann jamesdann is offline email address formatting in a cell Windows 7 32bit email address formatting in a cell Office 2010 32bit
Banned
 
Join Date: Jan 2014
Posts: 26
jamesdann is on a distinguished road
Default

This method also prevent Excel to creating Hyperlinks automatically when type entries with prefixes like http://, www., mailto:, ftp:, etc.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Many URLs in one email by common email address instantaphex Mail Merge 3 04-29-2013 05:46 PM
email address formatting in a cell Outlook won't reply/forward email from one email address rluna68 Outlook 2 01-07-2013 12:42 PM
Changing Cell address within a formula vermont_past Excel 12 09-21-2012 12:15 PM
COUNTIF and Cell address problem ColinC Excel 3 12-24-2011 04:08 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft