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

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

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

=IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)

--
Kevin Vaughn


"Cr character on numbers" wrote:

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

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

Thank Kevin, It works

"Kevin Vaughn" wrote:

=IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)

--
Kevin Vaughn


"Cr character on numbers" wrote:

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

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

You're welcome.
--
Kevin Vaughn


"Cr character on numbers" wrote:

Thank Kevin, It works

"Kevin Vaughn" wrote:

=IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)

--
Kevin Vaughn


"Cr character on numbers" wrote:

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