Thread: text to numeric
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clem Clem is offline
external usenet poster
 
Posts: 18
Default text to numeric

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,