clearing a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to put the date in a single cell but another number is popping up
when i click enter. How can I get the date to stay and not that other number?
 
What date and what number?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Select the cell with the number, click FORMAT on the menu and select CELLS.
Click the Number tab and from the CATEGORY panel select DATE and then to the
right of that in the TYPE panel select the date display you want to use.
 
Back
Top