DataText to ColumnsNextNextAdvanced. Checkmark "trailing minuses" and
Finish.


Gord Dibben Excel MVP

On Thu, 14 Apr 2005 02:14:01 -0700, "Wallaby"
wrote:

The negative value in the AS400 system appears with the negative symbol after
the value, so when imported into excell it does not calculate it as a
negative value. How do I change that?