Formatting Numbers - Revision history

Hoecas11 at 02:40, 24 October 2011

2011-10-24T02:40:07Z

Hoecas11 at 01:46, 23 October 2011

2011-10-23T01:46:19Z

Hoecas11 at 01:43, 23 October 2011

2011-10-23T01:43:29Z

Hoecas11 at 01:43, 23 October 2011

2011-10-23T01:43:20Z

Hoecas11 at 01:43, 23 October 2011

2011-10-23T01:43:04Z

Hoecas11: Created page with '
75pxA nice feature of Excel is its ability to format numbers beyond basic figures. You can modify your spreadsheet to include …'

2011-10-23T01:42:41Z

Created page with '<div class="intro">75pxA nice feature of Excel is its ability to format numbers beyond basic figures. You can modify your spreadsheet to include …'

New page

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]A nice feature of Excel is its ability to format numbers beyond basic figures. You can modify your spreadsheet to include currency symbols, fractions, percentages, time, date, and numbers with commas.</div>

<br>

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.

← Older revision		Revision as of 02:40, 24 October 2011
Line 18:		Line 18:

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

← Older revision		Revision as of 01:46, 23 October 2011
Line 7:		Line 7:
	<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.

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

Formatting Numbers - Revision history

Hoecas11 at 02:40, 24 October 2011

Hoecas11 at 01:46, 23 October 2011

Hoecas11 at 01:43, 23 October 2011

Hoecas11 at 01:43, 23 October 2011

Hoecas11 at 01:43, 23 October 2011

Hoecas11: Created page with '75pxA nice feature of Excel is its ability to format numbers beyond basic figures. You can modify your spreadsheet to include …'

Hoecas11: Created page with '
75pxA nice feature of Excel is its ability to format numbers beyond basic figures. You can modify your spreadsheet to include …'