Excel 2000 Hyperlink

When I enter an email addrsss in a column, the hyperlink properties will setup automatically such that when i click the email address, outlook express will start automatically. But if I use copy and paste option for this column, hyperlink properities will not set up, therefore can’t run outlook express when i click the address. Now I made
a list of serveral hundred email address by copy and paste option by mistake, how can i set all the those hyperlink properities by just a few clicks or by marco, etc…