Text conversion to number

Ferengi

New Member
Joined
Dec 7, 2010
Messages
5
Good day all

I know there is someone that can assist. I work at a company who's accounting system always exports negative numbers/credits with the annotation of cr at the end of the number for eg, 1000cr, instead of -1000. Is there a formulae that one can use to change it to the latter?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,280
Office Version
  1. 365
Platform
  1. Windows
Try
=IF(RIGHT(A1,2)="cr",-SUBSTITUTE(LOWER(A1),"cr",""),A1)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,313
Messages
5,527,952
Members
409,794
Latest member
ajithppajith

This Week's Hot Topics

Top