T
Tim Zych
'@blah.com
apostrophe and @blah.com works too.
apostrophe and @blah.com works too.
Tim Zych said:and bless excel, because it was multiple cells
- it didn't mind,
then i just deleted the crap in the next cell
anyway- my work around was just to
type @blah<tab>vjjbhfdjdf
in notepad, pasted to excel,
and bless excel, because it was multiple cells
- it didn't mind,
then i just deleted the crap in the next cell
Richard Choate said:Tim,
Don't waste your time here. This person doesn't want any help and never did.
Richard
Yeah, but now try to edit it(F2) and then press Enter. As
long as you don't expect to ever change the value, your
way will work.
I'd stick with the apostrophe, or possibly formatting the
cell as text. If the cell is formatted as text, Excel
won't try to evaluate the contents.
manThe original querie was not the act of a troll, but more of a frustrated