If you have excel 2002 onward you can just select the range, do datatext to
columns and click finish
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Socal Analyst looking for help"
. com wrote in message
...
if i copy and paste data from an AS400 program (KBM or JD Edwards) how to
i
change 2000- to be -2000 or (2000) in excel
get rid of trailing minues and change them to brackets or to show negative
before the number?