Excel 2007 : Adding cells containing asterisks

Hi,

I know its probably an easy question but I am a beginner.
I have a number of cells I want to add up but some of them contains asterisks so excel just ignore those.
for ex. 2, 10*, 10**, and i want to say 22.

How can I force excel to ignore those and just add the numeric values?

thanks in advance!!