On Fri, 10 Mar 2006 07:56:28 -0800, JR wrote:

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.

Thanks

=INT(A1)


--ron