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.
ScottieIt doesn't matter for sorting:
2/13/2006
is really
38761and
2/13/2006 5:10
is really
38761.2154
The time is just the decimal (fractional) part of the date number.
--
Gary''s Studentquot;Scott Robsonquot; wrote:
gt; Hello, I know this question has been asked many times before but the
gt; answers given are a little hard to grasp.
gt;
gt; I'm trying to sort an excel file by date and some of the colums are
gt; merged.
gt; For example the date and time is merged. Can anyone please explain an
gt; easy way to do this?
gt;
gt; Ex: 21/12/2005 21:21:10
gt;
gt; Any advice must gratefully recieved.
gt;
gt; P.S - It's not for me.
gt;
gt;
gt;
gt; Scottie
gt;
gt;
- Oct 18 Sat 2008 20:46
Sorting By Date
close
全站熱搜
留言列表
發表留言