| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
I have cells with the following info:
4/14/2003 14:35 but i need to split so that i can sort by date alone. how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting information in cells | Excel Worksheet Functions | |||
| Splitting Date and Time | Excel Discussion (Misc queries) | |||
| Sumif a date time colum and information | Excel Discussion (Misc queries) | |||
| How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
Threaded Mode
