I just got a huge trial balance from a client that shows debit amounts as
positive and credit amounts with a "cr" after the number. This makes it
impossible to sum! Looks like this...

2,000
5,000CR
3,000
2,000CR

How can I convert those CR amounts into negatives (either minus sign or
using parentheses). It would take days to convert each one, and the Format
function does not work, unless I'm missing a step. Please help ASAP. This
is due tomorrow!
Thank you!