Remove apostrophe?

I am sure that this is a simple one but it has stumped me.

Does anyone know how to get rid of apostrophes surrounding a number in a cell? I have got table data from the web but it appears with apostrophes - I'd like to be able to remove these and convert to double.

Many thanks

Answer 1

[Image Analyst]

Did you try str2double()?

[David Jessop]

Thanks! I thought I'd tried that but clearly tried everything but!