From Help Wiki
In an Excel spreadsheet, the values you assign to a cell are of the default "General" style. This means that your table will display plain numbers--no commas or other flourishes. Cell formatting allows you to change the way your numbers look. For example, you probably wouldn't want your table to display the ".0" after a value if your data is dealing with strictly whole numbers.
The Format Cells dialog box allows you to do this--you can format a single cell, a row, a column, or a range of cells that you choose. Once you choose your desired cell format, you may go in and change details such as the way decimals are displayed, a specific country's currency, or other more specialized formatting.
When to Use This
- Changing currency
- Increasing or reducing digits displayed after a decimal
- Making values more readable to an audience
- Contact Academic Computing if you need additional help.