text to numeric

[CLEM]

I have imported data into Excel 97 and negative numbers appear in columns
like this:

123.45-
24.21-
1000.78-

These are text and will not allow any sums. How can I convert the above to
numeric values so they appear as follows:
-123.45
-24.21
-1000.78

OR

(123.45)
(24.21)
(1000.78)

Thanks,
(e-mail address removed)

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/postfixnegatives.html

 

[mohavv]

See

http://www.mcgimpsey.com/excel/postfixnegatives.html

Try following in the colomn next to imported

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

Cheers
Harold

 

[CLEM]

Thank you both, this solved my problem!!!!!!!!!!!!!!!!!