Tip of the week # 554
30 October 2018

Quick currency formatting fix (Microsoft Excel) *

You probably are aware that you can format your cells to display your country's currency symbol by simply clicking on the Accounting Number Format button on the Home tab. (Exactly. No need to click on the drop-down arrow next to the coins.) The Accounting format lines up the currency symbol on the left edge of the cell and that's exactly what I often hear people don't like. They prefer to apply the currency format, where the symbol is right next to the number. OK, you can right-click the cell and select Format Cells, but it's four clicks before you've applied the new format. (Not that I'm counting.) So why not use a keyboard shortcut.

Here's how:

  1. Press CTRL + SHIFT + 4

The shortcut is easier to remember if you think of it as CTRL + SHIFT + $.

Any zero values that were displayed as a dash when the Accounting format was used will now be displayed as zeros with decimals.

By the way, to choose Euros or Dollars instead of Pounds, simply click on the drop-down arrow next to the Accounting Number Format button.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.