Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default shortcut for increasing or decreasing the number of decimals

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default shortcut for increasing or decreasing the number of decimals

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


"JorisBK" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decreasing number of Values in Pivot Tables Value List Rohan Excel Discussion (Misc queries) 0 May 21st 07 09:45 AM
decreasing # to stop decreasing when <=0 Ken Excel Worksheet Functions 1 March 4th 07 07:02 AM
Keyboard Shortcut for More/Less Decimals JonOfAllTrades Excel Discussion (Misc queries) 4 June 15th 06 05:11 PM
increasing and decreasing a value in a cell cwal Excel Worksheet Functions 6 April 14th 06 06:55 PM
Increasing Number David Excel Discussion (Misc queries) 2 March 8th 06 01:40 PM


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"