Excel question for google csv download

[KidsBeeHappy]

Extracting a google keyword report into csv/excel, and the average CPC column gets downloaded in a text format "£1.18"

Now I can use the right function to extract just the relevant cost at the end, but it's still in text format. How can I get this in number format?

Thanks

[spreadsheetsdirect]

try a text to columns with ; as the seperator.

[spreadsheetsdirect]

If still in text use =value(cell) and then paste special values to get rid of the formula.