Great. Thank you...you wouldn't happen to have the solution or at least an
attempt at the subtotal loop question proposed on 3/9 also. No one has
responded yet. I might need to dangle a carrot out there or something.
Surely it's doable. Thanks again.

"Gord Dibben" wrote:

Try DataText to ColumnsNextNextAdvanced.

Checkmark "trailing minus for negative numbers".


Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 11:59:02 -0800, wilson@irco
wrote:

Using copy paste from AS400 to excel spreadsheet negative numbers do not read
negative because the negative sign remains on the right side of the number in
excel. Is there an easy way to flip the negative sign from the right side of
the number to the left side?