Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting By Date
Hello, I know this question has been asked many times before but the
answers given are a little hard to grasp. I'm trying to sort an excel file by date and some of the colums are merged. For example the date and time is merged. Can anyone please explain an easy way to do this? Ex: 21/12/2005 21:21:10 Any advice must gratefully recieved. P.S - It's not for me. :) Scottie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting By Date
It doesn't matter for sorting:
2/13/2006 is really 38761 and 2/13/2006 5:10 is really 38761.2154 The time is just the decimal (fractional) part of the date number. -- Gary''s Student "Scott Robson" wrote: Hello, I know this question has been asked many times before but the answers given are a little hard to grasp. I'm trying to sort an excel file by date and some of the colums are merged. For example the date and time is merged. Can anyone please explain an easy way to do this? Ex: 21/12/2005 21:21:10 Any advice must gratefully recieved. P.S - It's not for me. :) Scottie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
sorting data by date | Excel Worksheet Functions | |||
Sorting data by date | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions |