Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a large number of cells with date and time like this, "Jan 12,
2001 5:55 pm" I want to truncate the time in the cell and only make it display the date. Can someone help me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Text to Date using "Text to Columns" | Excel Discussion (Misc queries) | |||
If date is in the month of Sept, then "1", otherwise "2" | Excel Worksheet Functions | |||
Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
"NOW" or "TODAY" date function | Excel Worksheet Functions | |||
Showing "Created by User, Date, Time" in Footer | Excel Discussion (Misc queries) |