CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS

  • Thread starter Socal Analyst looking for help
  • Start date
S

Socal Analyst looking for help

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

CLR

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

=IF(RIGHT(A1,1)="-",SUBSTITUTE(A1,"-","")*-1,A1)

Vaya con Dios,
Chuck, CABGx3
 
Top