Number formatting allows you to apply formatting patters to numbers, and show numbers as percentages or currency.
APPLY NUMBER FORMAT PATTERNS
Highlight the cells and click on the Apply Number Format button, shown as a blue letter A. Before changing the format, you can view a preview of altered cells.
The format patterns include unformatted, number, currency, percentage, date/time, and custom. For number, currency, and percentage formats, you may decide the number of decimals places.
$ FORMAT SELECTION AS CURRENCY
The button, represented as $, applies a dollar sign, two decimals places, and thousands markers to numbers.
% FORMAT SELECTION AS PERCENTAGE
The button, shown as %, displays numbers as percentages.