add shortcut for increasing decreasing decimal

There are buttons of the ribbon that already do that. why re-invent the wheel?

I added those buttons to the "quick access toolbar" (I'm not sure if you are familiar with this feature). Items on the quick access toolbar can be quickly accessed by alt-#, where the number is chosen by the commands position on the toolbar. In mine, I have the increase decimal button as the 4th item on the quick access toolbar, so alt-4 increases decimal.

You can customize the quick access toolbar by clicking on the office symbol (alt-f), selecting Excel Options at the bottom, then "customize" to bring up the customize quick access toolbar menu. Add and remove buttons/commands as desired.

You can also use the alt key to access all of the ribbon commands. Press the alt key, and the key to access each ribbon group is displayed. Press that key to access that group and bring up the key sequence for the commands on that ribbon group. For example, the decrease decimal command can be accessed as alt-h (home group) -> 9. Only one more keystroke than putting the command on the quick access toolbar or using VBA to create a macro and assign it to a shortcut key.

Is this what you are looking for?

https://kb.wisc.edu/helpdesk/page.php?id=1567#Office 2007/2010/2013
or
http://help.isu.edu/index.php?action...=66&docid=1025

Outside of the standard Alt+H+9 or Alt+H+0, you could write your own macros and hotkey them under options. I put them as Ctrl+Shift+A, and Ctrl+Shift+S.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

.... deleted ....

The C functions of VB convert things. ConvertToString (CStr), ConvertToInteger(CInt), ConvertToLong(CLng), etc. that convert from data type to another.

It was possibly an unnecessary step, but the aim was to make sure the input of the number format was the string "0.00", "0.000", etc.