ExcelBanter - Convert Date Time in Spreadsheet Column to Date only

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert Date Time in Spreadsheet Column to Date only (https://www.excelbanter.com/excel-programming/300796-convert-date-time-spreadsheet-column-date-only.html)

Convert Date Time in Spreadsheet Column to Date only

12/24/2003 15:16:43:43
12/24/2003 15:16:43:43
12/24/2003 15:33:58:483
12/11/2003 12:30:40:36
11/3/2003 16:09:38:89
11/3/2003 16:00:48:076
1/13/2004 15:10:14:15
1/7/2004 08:26:32:383
1/7/2004 00:00:00
1/13/2004 11:07:42:92
1/7/2004 08:22:05:79

I need to convert date and time in a column to date only. Please help.

Thanks
Geng

--
Message posted from http://www.ExcelForum.com

Convert Date Time in Spreadsheet Column to Date only

Hi Genga,

If the data just has to show as dates, select the data and Format
CellsCustom and enter "mm/dd/yyyy" in the dialog box.

If you really want to remove the time part:

=INT(A1)

"Genga " wrote in message
...
12/24/2003 15:16:43:43
12/24/2003 15:16:43:43
12/24/2003 15:33:58:483
12/11/2003 12:30:40:36
11/3/2003 16:09:38:89
11/3/2003 16:00:48:076
1/13/2004 15:10:14:15
1/7/2004 08:26:32:383
1/7/2004 00:00:00
1/13/2004 11:07:42:92
1/7/2004 08:22:05:79

I need to convert date and time in a column to date only. Please help.

Thanks
Genga

---
Message posted from http://www.ExcelForum.com/