software

Hello,

I would like help changing the following from:

2005-01-02 11:19:44

to the date only. I know I can reformat the cell; however when I pivot off
the formatted cell the cell still shows the time. Your help is appreciated.

ThanksOn Fri, 10 Mar 2006 07:56:28 -0800, JR gt; wrote:

gt;Hello,
gt;
gt;I would like help changing the following from:
gt;
gt;2005-01-02 11:19:44
gt;
gt;to the date only. I know I can reformat the cell; however when I pivot off
gt;the formatted cell the cell still shows the time. Your help is appreciated.
gt;
gt;Thanks

=INT(A1)--ron

JR

=TEXT(A1,quot;mm/dd/yyquot;)

Beege

quot;JRquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I would like help changing the following from:
gt;
gt; 2005-01-02 11:19:44
gt;
gt; to the date only. I know I can reformat the cell; however when I pivot
gt; off
gt; the formatted cell the cell still shows the time. Your help is
gt; appreciated.
gt;
gt; Thanks
gt;