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.
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.