Minus sign at the end of number

I am exporting data from a software to excel. But I have a problem since all the negative number are written with the negative at the end of the number instead of the beginning (don't ask me why). So what I would like to do is a find and replace to find any number that has a minus sign at the end and put the minus sign at the beginning. Is there any way to do so. By the way, the numbers can be anywhere from A1 to BG20677. So I can't make a macro that go cells by cells to see if there is a minus sign.

Thanks a lot,

Cope

Have you tried just adjusting the cell formatting? It might just be custom format which you could change in one fell swoop.

I took a look at what you said and I could take a number with a minus sign at the beginning and put it at the end, but I can't make the opposite since excel does not recognize my negative numbers as numbers.

Thanks for your help, if you have any other ideas please let me know,

Cope

Thanks a lot, the the macro sent by Phil_V worked out great for me. I haven't try the other ones but thanks a lot to all of you.

Cope