I'm working from a download excel file that I copy and paste to an existing
work book.  I have a sumif formula that i'm using to pull information from
the download but am running into a problem with the  "cr" (for credit) in my
download.  I need for it to show  "-" or "( )" .  Is their a formula I can
include in my existing workbook to make this conversion, or maybe a macro(
which i've never worked with).  
 
      a           b          

1       1cr      2cr

needs to be:
      a          b

1       -1 or  (2)

I hope I have supplied enough information.

Thank you.