Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Convert date and time | Excel Discussion (Misc queries) | |||
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
Convert date to length of time in months from set date | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |