| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
