When Numeric keypad will not work in Excel, following steps performs:
Step-1: Open Control Panel.
Step-2 : Click on "Ease of Access Center".
Step-3: Click on "Make the keyboard easier to use".
Step-4: Uncheck on "Turn on Mouse Keys".
Step-5: Apply and Ok. check now