importing a text file with negative numbers into excel?

[jstnvndn]

When you have a text file and the numbers have the minus sign after the number, how do you import it to excel and get the numbers recognized as a negative?

[starguy]

When you have a text file and the numbers have the minus sign after the number, how do you import it to excel and get the numbers recognized as a negative?

you need to change numbers to negative values by using a formula
if you have numbers imported in col A starting from cell A1 put in B1,

=IF(RIGHT(A1,1)="-","-"&MID(A1,1,LEN(A1)-1),"")*1
and copy this formula down to the extent you have data in col A
to remove formula and to keep just result of formulas (i-e negative numbers)
copy col B right click on col B select paste special and select values, Ok

hope this would help.

Regards.