Changing minus values

[shaddy]

I am importing (cut/paste) data which reflects minus numbers as: 100-.
When put into my w/sheet excel will not recognise its value when
ranked. I need to convert 100- to an excel acceptable format i.e.
(100) or -100. Is there any function or macro that would achieve
this?

Thanks for any help or direction
Keith C

 

[JS]

try the following formula in the column next to your data

=IF(E5="-","-" & LEFT(D5,LEN(D5)-1),D5)

 

[Dale Hymel]

try this if C3 contains the XXX-

=IF(RIGHT(C3,1)="-",-VALUE(LEFT(C3,LEN(C3)-1)),C3)