|
Featured Tutorial
Featured Macro
Mr Excel & excelisfun Trick 45: + 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 and 2) Use Custom Number formatting to make a number appear to have a leading + and -.See the functions LEFT, LEN, MID