You can't do it by formatting alone.

You could use a macro to do the insert|hyperlink based on the contents of the
cell -- or even easier you could use another column with a formula like:

=hyperlink(a1,"email me")
or
=hyperlink("mailto:" & a1,"email me")


FrankSpokane wrote:

I imported a text file that has names and email addresses.
How do I format the column with the email addresses so they become real html
email address instead of plain text.

Thanks to all replies.

--

Dave Peterson