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?

CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
 

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?

CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
 

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?