G
Guest
When I enter the date as 1/2 and hit enter, it automatically display as
39114. Then I went Format>cell>number>click 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.
39114. Then I went Format>cell>number>click 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.