Microsoft Office Tutorials and References
In Depth Information
Entering text
number for June 1, 2010, is 40330. Noon on June 1, 2010 (halfway through the day), is
represented internally as 40330.5 because the time fraction is added to the date serial number to get
the full date-and-time serial number.
Again, you normally don’t have to be concerned about these serial numbers (or fractional serial
numbers, for times). Just enter the time into a cell in a recognized format.
The following table shows some examples of time formats that Excel recognizes.
Entered into a Cell
Excel’s Interpretation
11:30:00 am
11:30 AM
11:30:00 AM
11:30 AM
11:30 pm
11:30 PM
11:30 AM
1:30 PM
These examples don’t have days associated with them, so they’re represented internally as values
less than 1. In other words, Excel is using the nonexistent date January 0, 1900. You also can
combine dates and times, however, as shown in the following table.
Entered into a Cell
Excel’s Interpretation
6/26/10 11:30
11:30 AM on June 26, 2010
6/26/10 12:00
Noon on June 26, 2010
6/26/2010 0:00
Midnight on June 26, 2010
When you enter a time that exceeds 24 hours, the associated date for the time increments
accordingly. For example, if you enter the following time into a cell, it’s interpreted as 1:00 AM on
January 1, 1900:
The day section of the entry increments because the time exceeds 24 hours. Keep in mind that a
time value without a date uses January 0, 1900, as the date.
Entering text
If Excel can’t interpret your cell entry as a value, a date, a time, or a formula, it goes into the
catchall category of text.
A single cell can hold a massive amount of text — about 32,000 characters. However, you’ll see
that Excel has lots of limitations when you use large amounts of text in a cell. In fact, it can’t even
Search JabSto ::

Custom Search