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

Submit a Comment

Your email address will not be published. Required fields are marked *