Difference between revisions of "Formatting Numbers"
From Help Wiki
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
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. | 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. | ||
| + | |||
<br> | <br> | ||
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. | 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. | ||
| + | |||
| + | <br> | ||
| + | ====When to Use This==== | ||
| + | # Changing currency | ||
| + | # Increasing or reducing digits displayed after a decimal | ||
| + | # Making values more readable to an audience | ||
| + | <br> | ||
| + | |||
| + | ====Additional Help==== | ||
| + | |||
| + | *Contact [http://rails.evergreen.edu/contact/?site=ac-computing-help&recipient=acadcomphelp&tt=true&subject=Email%20from%20the%20Moodle%20Assignments%20Help%20Page Academic Computing] if you need additional help. | ||
| + | |||
| + | [[Category:Excel]] | ||
Latest revision as of 18:40, 23 October 2011
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
Additional Help
- Contact Academic Computing if you need additional help.
