Specific question on excel  

Ok, so I work with excel '07 quite a bit and I am fairly familiar with it, not a pro by any means mind you, and I know/understand nada about macros, lol. So here's the deal. You know when you have a hyper-linked email in the excel file that just reads as "email" in blue and underlined, but if you click on it it will open you set email system to send an email, right... So here is what I am trying to do: I have a list of about 6k of these hyper-linked emails, and what I need is to have the actual email displayed not the "email" hyper-linked, does this make any sense? No I have looked and looked and have not found a shortcut or function for doing this, but I feel that it would have been in very poor design for them not to have put this in somewhere and I am just not getting it, lol. So, any help, ideas, suggestions would be great.. Cheers!