How to get rid of $ signs in cells?

I don't understand what has happened. I managed to delete all the $ signs earlier on but now i can't. All i get is a pop up box saying Excel can't find any data to replace. Don't know why. Any ideas?

Are the cells formatted as "currency"? If so, change to Number.

Tried that originally. I had managed to find and replace the $ sign a couple of hours ago but now when I try and do it it won't let me.

AndyC,could you post a sample of your data under zipped .xls format? (I'm not familiar with xlsx)
Thx

Looks like I managed to suss it out. I have now managed to get rid of the $ signs on each of the necessary columns. Hopefully this has now sorted it. Hopefully!