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

=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

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

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