Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
date: Fri, 29 Aug 2008 18:52:13 +0800,    group: microsoft.public.excel        back       


sorting base on date    
how to sort based on a column  of date that has either dd.mm.yyyy or 
dd/mm/yyyy
date: Fri, 29 Aug 2008 18:52:13 +0800   author:   crapit

Re: sorting base on date    
As Excel stores dates as the number of days since 1900, sorting should be no 
problem, irrespective of the format they are shown in.

-- 
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"crapit"  wrote in message 
news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl...
> how to sort based on a column  of date that has either dd.mm.yyyy or 
> dd/mm/yyyy
>
date: Fri, 29 Aug 2008 13:09:06 +0100   author:   Bob Phillips

Re: sorting base on date    
Change all your text dates to real dates.

If they are all in dmy order, then I'd go into windows control panel and make
sure my short date is set to this same dmy order.

Then just change all the . to / 
and change all the / to /

And then I would give that range an unambiguous date format (mmmm dd, yyyy) and
check if my dates are what I expect them to be.  Your results could be
dates--just not what they really should be.

Then sort your data.

And after you've verified them, you can change the windows short date back to
the order you like.

crapit wrote:
> 
> how to sort based on a column  of date that has either dd.mm.yyyy or
> dd/mm/yyyy

-- 

Dave Peterson
date: Fri, 29 Aug 2008 07:08:48 -0500   author:   Dave Peterson

Re: sorting base on date    
Before sorting

      01.11.1976

      31.08.1983

      24.11.1952

      24.06.2002

      23.04.1976

      18.12.1973

      16.05.1980

      05.09.1983
     
      After Sorting

      24.11.1952

      18.12.1973

      23.04.1976

      01.11.1976

      16.05.1980

      31.08.1983

      05.09.1983

      24.06.2002
     
  










But it doesnt works  as you had say in the previous reply


"Bob Phillips"  wrote in message news:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl...
> As Excel stores dates as the number of days since 1900, sorting should be no 
> problem, irrespective of the format they are shown in.
> 
> -- 
> HTH
> 
> Bob
> 
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
> 
> "crapit"  wrote in message 
> news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl...
>> how to sort based on a column  of date that has either dd.mm.yyyy or 
>> dd/mm/yyyy
>> 
> 
> 
>
date: Sat, 30 Aug 2008 20:55:07 +0800   author:   crapit

Re: sorting base on date    
Which of those has been sorted out of order in your view?

-- 
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

  "crapit"  wrote in message news:OZJzh%23pCJHA.4340@TK2MSFTNGP02.phx.gbl...
        Before sorting

        01.11.1976

        31.08.1983

        24.11.1952

        24.06.2002

        23.04.1976

        18.12.1973

        16.05.1980

        05.09.1983
       
        After Sorting

        24.11.1952

        18.12.1973

        23.04.1976

        01.11.1976

        16.05.1980

        31.08.1983

        05.09.1983

        24.06.2002
       
    










  But it doesnt works  as you had say in the previous reply


  "Bob Phillips"  wrote in message news:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl...
  > As Excel stores dates as the number of days since 1900, sorting should be no 
  > problem, irrespective of the format they are shown in.
  > 
  > -- 
  > HTH
  > 
  > Bob
  > 
  > (there's no email, no snail mail, but somewhere should be gmail in my addy)
  > 
  > "crapit"  wrote in message 
  > news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl...
  >> how to sort based on a column  of date that has either dd.mm.yyyy or 
  >> dd/mm/yyyy
  >> 
  > 
  > 
  >
date: Sun, 31 Aug 2008 18:27:30 +0100   author:   Bob Phillips

Re: sorting base on date    
it doesnt sort at all, i'm just showing a original unsort and after sort sample
  "Bob Phillips"  wrote in message news:%232b3964CJHA.3668@TK2MSFTNGP05.phx.gbl...
  Which of those has been sorted out of order in your view?

  -- 
  HTH

  Bob

  (there's no email, no snail mail, but somewhere should be gmail in my addy)

    "crapit"  wrote in message news:OZJzh%23pCJHA.4340@TK2MSFTNGP02.phx.gbl...
          Before sorting

          01.11.1976

          31.08.1983

          24.11.1952

          24.06.2002

          23.04.1976

          18.12.1973

          16.05.1980

          05.09.1983
         
          After Sorting

          24.11.1952

          18.12.1973

          23.04.1976

          01.11.1976

          16.05.1980

          31.08.1983

          05.09.1983

          24.06.2002
         
      










    But it doesnt works  as you had say in the previous reply


    "Bob Phillips"  wrote in message news:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl...
    > As Excel stores dates as the number of days since 1900, sorting should be no 
    > problem, irrespective of the format they are shown in.
    > 
    > -- 
    > HTH
    > 
    > Bob
    > 
    > (there's no email, no snail mail, but somewhere should be gmail in my addy)
    > 
    > "crapit"  wrote in message 
    > news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl...
    >> how to sort based on a column  of date that has either dd.mm.yyyy or 
    >> dd/mm/yyyy
    >> 
    > 
    > 
    >
date: Mon, 1 Sep 2008 15:16:13 +0800   author:   crapit

Re: sorting base on date    
Are you saying that this is what you would like to have happen, but it
doesn't happen now? I suspect that all your "dates" are really text
values, as a full-stop is not normally used to delimit dates. Convert
them to real dates as explained earlier, then you should be able to
sort.

Hope this helps.

Pete

On Sep 1, 8:16 am, "crapit"  wrote:
> it doesnt sort at all, i'm just showing a original unsort and after sort sample
>   "Bob Phillips"  wrote in messagenews:%232b3964CJHA.3668@TK2MSFTNGP05.phx.gbl...
>   Which of those has been sorted out of order in your view?
>
>   --
>   HTH
>
>   Bob
>
>   (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>     "crapit"  wrote in messagenews:OZJzh%23pCJHA.4340@TK2MSFTNGP02.phx.gbl...
>           Before sorting
>
>           01.11.1976
>
>           31.08.1983
>
>           24.11.1952
>
>           24.06.2002
>
>           23.04.1976
>
>           18.12.1973
>
>           16.05.1980
>
>           05.09.1983
>
>           After Sorting
>
>           24.11.1952
>
>           18.12.1973
>
>           23.04.1976
>
>           01.11.1976
>
>           16.05.1980
>
>           31.08.1983
>
>           05.09.1983
>
>           24.06.2002
>
>     But it doesnt works  as you had say in the previous reply
>
>     "Bob Phillips"  wrote in messagenews:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl...
>     > As Excel stores dates as the number of days since 1900, sorting should be no
>     > problem, irrespective of the format they are shown in.
>     >
>     > --
>     > HTH
>     >
>     > Bob
>     >
>     > (there's no email, no snail mail, but somewhere should be gmail in my addy)
>     >
>     > "crapit"  wrote in message
>     >news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl...
>     >> how to sort based on a column  of date that has either dd.mm.yyyy or
>     >> dd/mm/yyyy
>     >>
>     >
>     >
>     >
date: Mon, 1 Sep 2008 02:01:39 -0700 (PDT)   author:   Pete_UK

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us