How to apply a Number Format

1. To apply a number format, e.g. a dollar sign or decimal points – First, select the range you want to format.



2. Then click the ‘Home’ tab

3. Then, under the Number group – Click the number format you want to apply and Excel will execute it the command for you.

How-to-apply-a-Number-Format - 2


4. For financial values, you can also click the ‘Accounting’ Format.

How-to-apply-a-Number-Format - 3 

For percentages you can click the ‘Percentages’ Format.

And if you have large numbers to format – you can click the ‘Comma’ style. It is located next to the numbers command, as seen in the diagram below.

How-to-apply-a-Number-Format - 4


Lesson 36: How to change the number of decimal places in a selected number or numbers