Can't format cells

Hi


I'm trying to change the percentages of my cells to numbers. When I click format cells - numbers -- it doesn't have any effect as the cells remain as percentages. It is data downloaded from the web and I've checked that the worksheet is unlocked.

How can I format the cells back to numbers?

Thanks

It's data downloaded from the web so I'm assuming it's numbers with text percentages in front but I can't change it...

OK I have these numbers which I need to be multiplied in the easiest way:

Please Login or Register  to view this content.

Using * with the cell I want multiplying them by gives a 'value' error and I'm sure that this is because they have $ infront. I've tried formatting cells and changing it to 'number' but the $ remains, even if I unlock the protection.

The only way to change them is to insert ABS(20.26) in front and that converts it to a number. However I'm having to do this manually at the moment and it will take ages for all the data. Is there an easier way or a way to have this done automatically?

Thanks

Please guide me through what steps I need to do:

I need the revenue column and column B (heading E) as numbers and not currencies. I don't want to have to do it manually for all the data by adding ABS or manually deleting the $sign.

Sample workbook attached.

Thanks

ok in Text to Columns, I'm clicking:

Deliminated - next -

Deliminaters: tick tabs and other - the symbol is $ - next

tick the general box

Finish

And the data is deleting itself instead of deleting the $ so I'm left with blank columns...

What am I doing wrong?

Thanks