Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.