Dueling Excel 045


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

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply