IF you want the date to be 01-feb then try the custom format of dd-mmm

John

"pamwp" wrote:

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.