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?

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

    software

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