More or Less

For my readers who are fairly new users of MS Excel, here’s a quick, yet infinitely useful tip for changing the number of decimal places displayed in one of your cells!

You’re looking for these two buttons located on the Formatting toolbar or in Excel 2007, they’re on the Home ribbon, Number section:

(If you’re using older versions of Excel and you don’t see them, go to the View menu, Toolbars submenu and choose Formatting from the list).

The button on the left will add decimal places to numbers in highlighted cells.

The button on the right will reduce the number of decimal places in highlighted cells. (As decimal places are reduced, the value displayed in the cell is rounded. However, if you take a look in the formula bar, you’ll see that Excel still has the exact value stored away safely in its memory).

More or less is just a click away!

~ April