close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()