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.

how to apply a number 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.

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 3




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