Dueling Excel 045

+ or with Formula or Custom Number Formatting Math Plus or Minus


See Mr Excel and excelisfun:
1) create a formula to extract a number from a text string that can be used for calculations.
2) Use Custom Number formatting to make a number appear to have a leading + and -.See the functions LEFT, LEN, MID