Microsoft Office Tutorials and References
In Depth Information
Date: Enables you to choose from several different date formats
Time: Enables you to choose from several different time formats
Percentage: Enables you to choose the number of decimal places and always
displays a percent sign
Fraction: Enables you to choose from among nine fraction formats
Scientiﬁ c: Displays numbers in exponential notation (with an E): 2.00E+05 =
200,000; 2.05E+05 = 205,000. You can choose the number of decimal places to
display to the left of E. The second example can be read as “2.05 times 10 to the ﬁ fth.”
Text: When applied to a value, causes Excel to treat the value as text (even if it
looks like a number). This feature is useful for such items as part numbers and
credit card numbers.
Special: Contains additional number formats. In the U.S. version of Excel, the
additional number formats are Zip Code, Zip Code +4, Phone Number, and Social Security
Custom: Enables you to deﬁ ne custom number formats that aren’t included in any
If a cell displays a series of hash marks (such as ######### ), it usually means that the column isn’t wide enough
to display the value in the number format that you selected. Either make the column wider or change the number
This chapter showed you the techniques you need to know to enter the contents for any
worksheet in Excel. You learned how Excel treats different types of information—text,
numbers, and formulas. You can continue on to learn to use ranges, because at this point,
you should be able to do the following:
Enter numeric, text, date, and time values.
Erase, replace, and edit cell contents.
Take advantage of a variety of shortcuts for entering data, including Auto Fill,
AutoComplete, and Flash Fill.
Apply number formatting to ensure your data is easy to interpret.