Excel Forum



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





Got a Question? Ask it Here in the Forum.