Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 214
30 November 2007

Start each week with a free tip

To subscribe, please type your email address in the box below:

keyboard shortcut to apply currency or percent format (Microsoft Excel)

Yesterday I was working at a client's site and was confronted with a dinky little keyboard that is supposed to relieve the symptoms of Repetitive Strain Injury (RSI). As you probably know, many people develop RSI in their mouse hand because of the constant movement back and forth from the mouse to the keyboard. OK, keyboard shortcuts can help, but the problem is that not a lot of people know them. Hence my mission and here are two more - I believe - intuitive ones for Excel.

  1. to apply percent format : press CTRL+SHIFT+%
  2. to apply currency format : press CTRL+SHIFT+$

By the way, although you type a dollar sign, the currency style applied will depend on the regional settings for currency in your Control Panel. So for our British readers this means pound sterling. For our Dutch readers ... Happy Sinterklaas!

Until next week.

Email this page to a friend

Enter recipient’s email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
November 2007