close

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 :-)
------------------------------*------------------------------*----------------quot;aheggquot; gt; wrote in message
...
gt; I'm trying to put the date in a single cell but another number is popping
gt; up
gt; when i click enter. How can I get the date to stay and not that other
gt; 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 Backmannquot;aheggquot; wrote:

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()