H2 Convert number with negative sign on right

[Guest]

How do you convert downloaded data where the negative sign appears on the right side of a number as opposed to the left? Excel is recgonizing it as text. I tried to format the cell to a number but excel is still reading it as text. i.e. 92.50- needs to be converted to -92.50.

 

[Guest]

=VALUE("-" & LEFT(A1,LEN(A1)-1))

 

[IML]

or
=IF(ISNUMBER(A1),A1,LEFT(A1,LEN(A1)-1)*-1)

if you have positives and negatives in your list.