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