Microsoft Office Tutorials and References
In Depth Information
Entering Dates
When you enter multiple lines of text within a cell, Excel confi nes the text within the
cell’s borders, increasing the cell’s height, if necessary, to show all of the text. As you can
see, the text in cell C2 appears on four lines even though you entered the address on two
lines. The automatic refl ow of text within a cell is referred to as wrapping. If the cell’s
width were increased, the text would then appear on two lines as Amanda wants. You’ll
do this in the next session.
To force text that extends
beyond a cell’s border to
fit within the cell, click the
Wrap Text button in the
Alignment group on the
Home tab. The row height
increases as needed to
wrap all the text within
the cell.
Entering Dates
You can enter dates in any of the standard date formats. For example, you can enter the
date April 6, 2013 in any of the following date formats (and many others) and Excel
recognizes each entry as representing the same date:
• 4/6/2013
• 4/6/13
• 4-6-2013
• April 6, 2013
• 6-Apr-13
Even though you enter a date as text, Excel stores the date as a numeric value equal
to the number of days between the specifi ed date and January 0, 1900. This means that
the date January 1, 1900 has a value of 1 and so forth. Times are also entered as text and
are stored as fractional parts of a 24-hour day. Storing dates and times as numeric values
allows Excel to perform date and time calculations, such as determining the elapsed time
between one date and another.
Based on the default date format your computer uses, Excel might alter the date
format you type. For example, if you enter the date 4/6/13 into the active cell, Excel
might display the date with the four-digit year value, 4/6/2013; if you enter the text
April 6, 2013, Excel might convert the date format to 6-Apr-13. Changing the date or
time format doesn’t affect the underlying date or time value.
For Amanda’s workbook, you’ll enter the dates in the format m/d/yyyy , where m is the
1- or 2-digit month number, d is the 1- or 2-digit day number, and yyyy is the 4-digit year
number. You will enter the order date on the Sheet2 worksheet and the current date in
the Sheet1 worksheet.
To enter the dates for the customer orders:
1. Type 3/13/2013 in cell D2, and then press the Tab key to move to cell E2. The
date of Gregory Dawes’s order appears in cell D2, and cell E2 becomes the active
cell. The width of column D expands to display the full date.
2. Click the Sheet1 sheet tab. The Sheet1 worksheet is the active worksheet.
3. Click cell to make it active, insert the current date using the format m/d/yyyy , B4
and then press the Enter key.
4. Click the Sheet2 sheet tab. The Sheet2 worksheet is the active worksheet, and
cell E2 is still the active cell.
Search JabSto ::

Custom Search