microsoft public excel newusers tips
 

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

microsoft public excel newusers tips
 

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