ExcelBanter - clearing a cell

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - clearing a cell (https://www.excelbanter.com/new-users-excel/80912-clearing-cell.html)

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 :-)
------------------------------*------------------------------*----------------

"ahegg" wrote in message
...
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?

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.
--
Kevin Backmann

"ahegg" wrote:

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?