Date Format

J

JR

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
 
R

Ron Rosenfeld

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
Click to expand...

=INT(A1)


--ron
 
Top