Negative text strings
3,272-
2,400-
2,000-
1,875-
1,300-
1,000-
Positive text strings
6,500
2,500
2,400
1,575
1,400
1,150
Using a formula such as this returns the expected result, but it forces the user to enter the strings in another cell. I would prefer the user simply paste the strings directly into the cell which would require the use of VBA
=IF(ISERROR(IF(ISNUMBER(FIND("-",$D45)),-SUBSTITUTE($D45,"-",""),SUBSTITUTE($D45,"+",""
)+0)),"",IF(ISNUMBER(FIND("-",$D45)),-SUBSTITUTE($D45,"-",""),SUBSTITUTE($D45,"+",""
)+0))
Thanks for the help
-ep