A faster way is to select the
cell (or range) and 'right click'.
This is a convenient way of accessing
various frequently used functions.
Notice that selecting 'Format
Cells' brings up a submenu that
allows you to change the font
style size and color. You can
also change the formatting to
currency ($) or percentage (%).
You can also increase or decrease
the number of decimal places ()
even if you restrict the number
of decimal places that are displayed
the full accuracy is still used
In the example the value in cell
C2 is actually 3.14 but has been
formatted to show only 1 decimal
place. The calculation shown in
cell C3 uses the actual value.