shortcut for increasing or decreasing the number of decimals

J

JorisBK

All,

By using CRTL+SHIFT+1 I can change the cell format into the Number format.
What shortcut can I use to increase or decrease the number of decimals?

Look forward to hearing from you,

Joris
 
B

Bernie Deitrick

Joris,

Right click a commandbar, select Customize, then the Commands tab, and then the Format category.
Scroll down in the Commands window to find the "Increase decimal" and "Decrease decimal" buttons,
and drag them to any commandbar - mine are next to the other formatting commands.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Custom Number sequences 0
Excel does not accept text format! 0
Trim varying decimals from column of numbers 9
Change number from multiple decimals to 2 3
increasing or decreasing a cell 16
Rounding Numbers. 2
VBA for Dependents shortcut menu 0

Top