Want to treat e-mail addy as text!
 

I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike

Want to treat e-mail addy as text!
 

1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'


HTH,
JP


"Mike" wrote:

I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike

Want to treat e-mail addy as text!
 

Sorry - the apostrophe has no effect - Mike


On Nov 19, 2:51 pm, JP wrote:
1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'

HTH,
JP



"Mike" wrote:
I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike- Hide quoted text -

- Show quoted text -

Want to treat e-mail addy as text!
 

My mistake, you need to remove the hyperlink first.

Right-click on the cell, choose "Remove Hyperlink"

Then

1. Hit F2 to edit the cell
2. 'Home' key to go to beginning of cell
3. Type ' (single apostrophe)

This should fix the cell. If you have a lot of cells to fix, highlight
them, then

1. Alt-F11 to open the VB Editor
2. Ctrl-G to open Immediate Window
3. Type "selection.hyperlinks.delete" (without quotes) and hit Enter


HTH,
JP


On Nov 19, 2:57 pm, Mike wrote:
Sorry - the apostrophe has no effect - Mike

On Nov 19, 2:51 pm, JP wrote:



1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'

HTH,
JP

"Mike" wrote:
I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Want to treat e-mail addy as text!
 

On Nov 19, 4:29 pm, JP wrote:
My mistake, you need to remove the hyperlink first.

Right-click on the cell, choose "Remove Hyperlink"

Then

1. Hit F2 to edit the cell
2. 'Home' key to go to beginning of cell
3. Type ' (single apostrophe)

This should fix the cell. If you have a lot of cells to fix, highlight
them, then

1. Alt-F11 to open the VB Editor
2. Ctrl-G to open Immediate Window
3. Type "selection.hyperlinks.delete" (without quotes) and hit Enter

HTH,
JP

On Nov 19, 2:57 pm, Mike wrote:



Sorry - the apostrophe has no effect - Mike

On Nov 19, 2:51 pm, JP wrote:

1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'

HTH,
JP

"Mike" wrote:
I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

JP - thanks, that worked - Mike