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

Rounding Numbers. 2
Trim varying decimals from column of numbers 9
increasing or decreasing a cell 16
shortcut key required... 2
decimals 2
How to retrieve number of visible digits after decimal point in VBA 5
Change number of decimals but retain original style 3
excel 2003 zero as last decimal 5

Top