Working with Dates in Excel
|Formatting Issues||Back to List of Topics|
||Sometime a user
may enter a number, say 35,345.56, and upon pressing Enter
10/17/96 displays in the cell. Inexperienced users may become very frustrated and not be able to get the number to display as desired.
In this example, we pressed Delete. Pressing Delete is the keyboard shortcut for Selecting Edit (in the menu) Clear Contents; deleting the contents of the cell, leaving the formatting in place.
Therefore, when you later came back to this cell to make a regular number entry, Excel simply used the format that was already there.
There are several simple ways to solve the problem, two of which follow:
Reminder: Cells retain their format until changed. When you make entries such as dates, you formatted the cell on the fly. If an entry is later made in that cell that is not a date, it will display in the date format anyway.
Try this: In an unformatted cell, enter $12,784.55 in a cell (enter the dollar sign, comma and decimal along with the numbers). Then press Delete and enter a date such as 9/6/96. You will get the Excel serial number rather than the date. This example is the reverse of the first example in this article, you formatted the cell on the fly by typing the format along with the number. That cell will hold this format until the format is changed.