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,

text to numeric
 

See

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

In article ,
CLEM wrote:

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,

text to numeric
 

On Oct 16, 2:51 pm, JE McGimpsey wrote:
See

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

In article ,

CLEM wrote:
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,


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

text to numeric
 

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

"mohavv" wrote:

On Oct 16, 2:51 pm, JE McGimpsey wrote:
See

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

In article ,

CLEM wrote:
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,


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