Help... in excel.
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.
|