Right click and choose "Hyperlink" then email. You might have success
converting them in one go by Replacing @ with @.


--
Regards
Dave Hawley
www.ozgrid.com
"snack" wrote in message
...
dear friends,
Someone sent me a spreadsheet with a column for email addresses.
Only
some of the addresses are clickable links and I thought I'd do
everyone
a service and fix the cells that aren't formatted properly and sent
the
spreadsheet back out again. (It's a team list for one of my kids'
sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?
www.rangefindecamera50webs.com