RTG Sunderland  Message Boards    
 
  • www.readytogo.net
  • www.a-love-supreme.com

  • Go Back   RTG Sunderland Message Boards > Sunderland Message Boards > SMB

    Notices

    Register and logon to remove this advert

     
     
    Thread Tools Display Modes
    Prev Previous Post   Next Post Next
    Old 1st August 2011, 09:02 PM   #1
    rokerexile
    Midfield
     
     
    Join Date: Feb 2003
    Location: 56
    Default Excel Help - sorting dates

    I am trying to sort some data in excel by dates (dd/mm/yyyy) but it is just looking at the dd bit and not sorting by the date as a whole. For example, if I have a date of 13/02/1834 and a date of 20/03/1776 and I want to sort by earliest date first I get the wrong result because 13 is earlier than 20 and it ignores the rest. Anybody know how to solve this, I'm a bit rusty with Excel?
    __________________
    Who can say that fortune grieves him, while the star of hope she leaves him...
    rokerexile is offline  
     

    Bookmarks

    Thread Tools
    Display Modes

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off

    Forum Jump


    All times are GMT +1. The time now is 01:01 PM.


    Powered by vBulletin
    Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
    Copyright © Ready To Go 1998-2013
    Page generated in 0.07373 seconds with 13 queries

    Partially Powered By Products Found At Lampwrights.com