Microsoft Office Tutorials and References
In Depth Information
Entering time values
For more information about working with dates and times, see Chapter 16, “Working with Dates and Times.”
Entering time values
When you work with times, you extend Excel’s date serial number system to include
decimals. In other words, Excel works with times by using fractional days. For example, the
date serial number for June 1, 2013, is 41426. Noon on June 1, 2013 (halfway through the
day), is represented internally as 41426.5 because the time fraction is added to the date
serial number to get the full date/time serial number.
Again, you normally don’t have to be concerned with these serial numbers or fractional
serial numbers for times. Just enter the time into a cell in a recognized format. In this
case, type June 1, 2013 12:00 .
Modifying Cell Contents
After you enter a value or text into a cell, you can modify it in several ways:
Delete the cell’s contents.
Replace the cell’s contents with something else.
Edit the cell’s contents.
You can also modify a cell by changing its formatting. However, formatting a cell affects only a cell’s appearance.
Formatting doesn’t affect the cell’s contents. Later sections in this chapter cover formatting.
Deleting the contents of a cell
To delete the contents of a cell, just click the cell and press the Delete key. To delete more
than one cell, select all the cells that you want to delete and then press Delete. Pressing
Delete removes the cell’s contents but doesn’t remove any formatting (such as bold, italic,
or a different number format) that you may have applied to the cell.
For more control over what gets deleted, you can choose Home
Editing
Clear. This
command’s drop-down list has fi ve choices:
 
Search JabSto ::




Custom Search