Microsoft Office Tutorials and References
In Depth Information
Date and Time
INSIDE OUT How to enter alternate currency symbols
Most PC keyboards sold in the United States allow you to enter only a single currency
symbol—the dollar sign—directly. To enter a currency symbol that isn’t represented
on your keyboard, you need to jump through a hoop or two. The simplest option is
to click the Insert tab and click Symbol. In the Symbol dialog box, click the Currency
Symbols subset, choose a symbol, and then click Insert. If you regularly use one or two
alternate symbols and you have a full-size keyboard with a numeric keypad, memorize
the ASCII codes for those symbols so you can enter them as needed. To enter the Euro
symbol (€), use the numbers on the numeric keypad (not those on the number row at
the top of the keyboard) and enter Alt+0128. The British pound symbol (£) is Alt+0163,
and the symbol for the Japanese Yen (¥) is Alt+0165. In Excel, you can use the Number
tab of the Format Cells dialog box to choose from a list of hundreds of currency
symbols when you choose either the Currency or Accounting formats.
Date and Time
When the text or number you enter in a cell matches any of the built-in Windows date
formats, Excel converts that entry to a serial number and formats the cell using the closest
matching Date format. If the date you enter includes only the month and date, Excel adds
the current year.
To choose a custom format, click the Date category in the Format Cells dialog box and
choose one of the options in the Type list, as shown on the next page.
The formats at the top of the list, preceded by an asterisk, represent the Short Date and
Long Date options as defined in the Region And Language section of Windows Control
Panel. You can apply these two formats most quickly by using the Short Date and Long
Date choices on the Number Formats list (in the Number group on the Home Tab). If you
choose a different format, look at the Sample box above the Type list to see how the
current cell contents will be displayed using that format.
When you enter a set of numbers that contain a colon (:) and that can be interpreted as a
time, Excel converts your entry to a serial number and applies the default Time format if
possible. If the number is followed by a space and A, P, AM, or PM (in caps or lowercase),
Excel adds AM or PM to the display format.