Precede the email address with an apostrophe (') when
keying.

HTH
Jason
Atlanta, GA

-----Original Message-----
I need email addresses in my excel worksheet, but they
must be text, not
hyperlink. Iv'e been copying them to a word doc, then
doing the "paste
special" to put it in excel as text. That works, but is
very time consuming.
Is there a way to format a column so emails are text
only?
--
"You can have everything in life you want, if you will
just help enough
other people get what they want." -- Zig Ziglar

.