Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date display as numbers
When I enter the date as 1/2 and hit enter, it automatically display as
39114. Then I went Formatcellnumberclick date and choose the type 14-Mar and click OK, Then when I enter the 1/2 and enter again, it will display as 1/02/2007 on the formular box, and will spill over to the next row. If I click the cell again, it will display 39114 again. I try to clear all the format, and still won't do any good. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel still changes numbers to date | Excel Discussion (Misc queries) | |||
Frogs in the pond - Display percentages not numbers | Charts and Charting in Excel | |||
Mileage Claim Formula | New Users to Excel | |||
How do I display the 'Date Modified' in an Excel worksheet header | Excel Discussion (Misc queries) | |||
Changing date serial numbers | Excel Discussion (Misc queries) |