Page 31 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 17

GETTING STARTED WITH EXCEL 1

If you cannot find a default DATE SYMBOLS DESCRIPTION
format you want for dates and
times, you can create custom d Use d to display days as 1-31 or dd to display days
date and time formats. To do as 01-31. Use ddd for a three-letter day name
so, you combine the codes, abbreviation, Mon-Sun. If you want the entire day
presented in the tables, for the name, use dddd.
day, year, month, hour, minute, m Use m to display months as 1-12 or mm to display
and seconds. You can use these months as 01-12. Use mmm for a three-letter
codes with any of the custom month name abbreviation, Jan. -Dec. If you want
number codes, such as the color the entire month name, use mmmm.
codes. For example, to display y Use yy to display a two-digit year, such as 01 or
the date and time as 3:45 PM yyyy to display the entire year.
March 14, 2002 in green, you
type: TIME SYMBOLS DESCRIPTION
h Use h to display hours as 0-23 or hh to display
Example:
single-digit hours with leading zeros, such as 09.
[Green]h:mm AM/PM mmmm dd, yyyy
M Use M to display minutes as 0-59 or MM to display
single digit minutes with leading zeros, such as 08.
Make sure to use a capital M, or Excel will view it
as months.
s Use s to display seconds as 0-59 or ss to display
single-digit seconds with leading zeros, such as 05.
AM/PM Displays either AM or PM with the specified time.

Custom

■ A list of current custom ˇ Type the desired custom ■ Excel applies the custom
formats displays in the Type format in the Type field. format to your cell selection.
box.
Á Click OK.

17