ExcelBanter - Date Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Format (https://www.excelbanter.com/excel-worksheet-functions/76539-date-format.html)

Date Format

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

Ron Rosenfeld

Date Format

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

Beege

Date Format

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

All times are GMT +1. The time now is 10:59 AM.