Call us on 01223 214177 or email us
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:
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.
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.