Hyperlinks - select the column - right click and you will see the remove hyperlinks option.
For the replace see the link below, as well as the $ symbol you will also need to do the same with the - symbol as what you have is a none standard symbol so you will need to copy it from your cell put it in the replace what box and type - in the replace with box.
Can't help you there as it does on mine if there are hyperlinks (and nothing if there isn't hyperlinks). You will have to look up how to do it in 2002 as I don't have a copy in front of me. You could try copying the column and pastespecial as values.
Or try running the sub below
went to another computer. both win7 both same version of excel.
those with a minus sign do not give the remove hyperlink option.
the positive numbers do give that option!
BTW i used to live in havant - also in southern england!
UPDATE they both now remove hyperlink but it is still text. will try the multi option
that only works on the positive ones!!!!
You need to do the 2 replaces as well as the remove hyperlinks (you don't need to select the individual cells, you can do the whole column in one). Btw Havant isn't far away from me
If you could post the actual file the I would do it for you but as that isn't an option maybe you could copy/paste the offending column to a different workbook then I could convert it, repost it and then you could paste it back rather than creating a whole new file.