adding up columns in excel

[LTS Tools, Inc]

Hello,
 
I am trying to download an excel spread sheet from ebay. Every time I do, the 
column with prices has an apostrophe before the number so I cannot add up the 
columns. My older version didn't do this. Please help!
 
Thank you,
Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone