software

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?

In a helper column, put this and copy down........

=IF(RIGHT(A1,1)=quot;-quot;,SUBSTITUTE(A1,quot;-quot;,quot;quot;)*-1,A1)

Vaya con Dios,
Chuck, CABGx3
quot;Socal Analyst looking for helpquot; wrote:

gt; if i copy and paste data from an AS400 program (KBM or JD Edwards) how to i
gt; change 2000- to be -2000 or (2000) in excel
gt;
gt; get rid of trailing minues and change them to brackets or to show negative
gt; before the number?

If you have excel 2002 onward you can just select the range, do datagt;text to
columns and click finish

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Socal Analyst looking for helpquot;
. comgt; wrote in message
...
gt; if i copy and paste data from an AS400 program (KBM or JD Edwards) how to
gt; i
gt; change 2000- to be -2000 or (2000) in excel
gt;
gt; get rid of trailing minues and change them to brackets or to show negative
gt; before the number?