View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cr character on numbers
 
Posts: n/a
Default 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