Take a look he

Convert trailing minus signs
http://www.mcgimpsey.com/excel/postfixnegatives.html

In article ,
"GEORGIA" wrote:

I have worksheet that has "-" on the right side of the number
14.59-
45.99-
I have used
=IF(RIGHT(J2,2)="-",-SUBSTITUTE(J2,"-",""),J2)
which logical test should return "True".

However, it is returning "false" for all of the numbers. even with ones
without "-" on the right.
I have text column to "General", "number" and "Text".

help!
Thank you!