This tip is for anyone who frequently adjusts the number of decimals visible in a number range. Sure, you know to hit Ctrl-1 to make it an orderly set of numbers, but what if you want only want to show the integer part, or if you want to see 4 decimal places? Instead of using the mouse to click the appropriate toolbar button, the trick lets you assign a hotkey to that, or any other toolbar button.
- Right click on the formatting toolbar and go to “Customize”.
- Right click on the toolbar button you want to assign a hotkey to (in our case, Decrease or Increase Decimal)
- If you want to make the hotkey “Alt-/” then change the text in the Name box to “&/”. If you have an “opposite” function, for example the opposite of Decrease Decimal is Increase Decimal, then this automatically makes Alt-Shift-/ perform that opposite.
- Change the button style to “Image and Text”. (If you want to disable your hotkey, you can change this back to Image only.)
- Close the Customize window, and you’re done!
(Adapted from Bankers Ball link above.)
