Select all the numbers with trailing minuses, do datatext to columns, click
next twice, in step 3 select
and make sure that trailing minus for negative numbers is checked, then
click OK and finish
From now on (after making sure that box is checked) you can just select the
column(s) and do datatext to columns
and click finish


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Oldersox" wrote in message
...
I have a situation whereby I am cutting and pasting a large volume of
negative values into Excel from another operating system and the the
negative
values are on the right side of the number which Excel 2003 does not
recognise as a number.
Is there a setting in Excel that will recognise the negative if the
character is on the right.
Or, is there a macro/vba to move the negative from the right eg. 500.00-
to the left eg. -500.00.