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