clearing a cell

A

ahegg

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?
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top