JR

=TEXT(A1,"mm/dd/yy")

Beege

"JR" wrote in message
...
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