CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS

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)="-",SUBSTITUTE(A1,"-","")*-1,A1)

Vaya con Dios,
Chuck, CABGx3



"Socal Analyst looking for help" wrote:

> 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?

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Socal Analyst looking for help"
<SocalAnalystlookingforhelp@discussions.microsoft.com> wrote in message
news:520ED4AD-FDB7-4A4E-8C62-BEAE24473EF1@microsoft.com...
> 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?