Cell formatting - email addresses

upchuck · Apr 29th, 2002, 08:19 PM

How can I tell Excel to quit treating email addresses as links and treat them as just text? I have 200+ email addresses to enter and don't want them as links. I'm hoping for a 'global,' easy solution, such as "Select the column where you want to do entry, do this [magic thing], then start entry."

Sugestions I've already heard:
Use 'undo' after entry.
Put a single quote as the first character.
Enter addresses somewhere else, cut them then use 'paste special - values only' to paste them where I want them.

All of these work but I'm hoping I can get Excel to treat an email address no differently than any other text.

Thanks!

upchuck

brettvba · Apr 29th, 2002, 08:38 PM

there should be a little blue line to the left under the email addy click that and choose stop automatically making hyperlinks
that should do it for you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 08:19 PM	#1
upchuck New Member Join Date: Apr 2002 Location: Louisville, KY, USA Posts: 1	How can I tell Excel to quit treating email addresses as links and treat them as just text? I have 200+ email addresses to enter and don't want them as links. I'm hoping for a 'global,' easy solution, such as "Select the column where you want to do entry, do this [magic thing], then start entry." Sugestions I've already heard: Use 'undo' after entry. Put a single quote as the first character. Enter addresses somewhere else, cut them then use 'paste special - values only' to paste them where I want them. All of these work but I'm hoping I can get Excel to treat an email address no differently than any other text. Thanks! upchuck

Apr 29th, 2002, 08:38 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	there should be a little blue line to the left under the email addy click that and choose stop automatically making hyperlinks that should do it for you