Hi

I use a free add-in from www.asap-utilities.com for this job. There are
loads of excellent (and useful) functions in the pack.

Andy.

"wilson@irco" wrote in message
...
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?