remove cr character from a + number and change number to - 159cr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help I want to remove the "cr" character from + number and change the
+ number to negative on a worksheet.
Example 215,814.58cr

Result= - 215,814.58

Thank you
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change positive number to negative number 1
HELP! Need to sum columns where credit balances are shown as ###CR 20
If then else needed in Excel 2007 3
How to subtract a number from a Mergefield? 0
Removing the CR DB trailer from a number xx.xxCR 2
removing the cr/lf characters? 1
Transpose & offset data from a table 7
How to change numbers from positive to negative. 2

Back
Top