software

I need help I want to remove the quot;crquot; 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) =quot;crquot;,VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)

--
Kevin Vaughnquot;Cr character on numbersquot; wrote:

gt; I need help I want to remove the quot;crquot; character from number and change the
gt; number to negative on a worksheet.
gt; Example 215,814.58cr
gt;
gt; Result= - 215,814.58
gt;
gt; Thank you

Thank Kevin, It works

quot;Kevin Vaughnquot; wrote:

gt; =IF(RIGHT(A21,2) =quot;crquot;,VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)
gt;
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;Cr character on numbersquot; wrote:
gt;
gt; gt; I need help I want to remove the quot;crquot; character from number and change the
gt; gt; number to negative on a worksheet.
gt; gt; Example 215,814.58cr
gt; gt;
gt; gt; Result= - 215,814.58
gt; gt;
gt; gt; Thank you

You're welcome.
--
Kevin Vaughnquot;Cr character on numbersquot; wrote:

gt; Thank Kevin, It works
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; =IF(RIGHT(A21,2) =quot;crquot;,VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)
gt; gt;
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;Cr character on numbersquot; wrote:
gt; gt;
gt; gt; gt; I need help I want to remove the quot;crquot; character from number and change the
gt; gt; gt; number to negative on a worksheet.
gt; gt; gt; Example 215,814.58cr
gt; gt; gt;
gt; gt; gt; Result= - 215,814.58
gt; gt; gt;
gt; gt; gt; Thank you