Sorting dates

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I got some advice before but I am still having problems sorting dates. Using
Excel 2003. I have a file of about 1000 records over a time span of 1750 to
1921.

When I sort by what I think is the date the order result is as follows...

1900 to 1921
followed by 1750 to 1899.

I can fix by moving a set of records to the bottom but that doesn't help if
the sort parameter is not the primary one.

Can I convert the date column to anything else to solve my problem.

I am not terribly interested in time between dates etc..

Thanks

Slán

Gerry


.

Relevant Pages

  • Sorting problem
    ... I am having problems sorting some data, I have an area of 19 columns and ... The problem is I go to tools and try to click sort but am unable to. ... Madstuthe1st's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25219 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: what level of infidelity is appropriate in a "relationship"?
    ... advice. ... idiot...she can sort of put it together. ... it's not that the physical chemistry is totally lacking......it's just ... "There is nothing patriotic about hating your country, ...
    (rec.sport.football.college)
  • [Long] New business: many questions (mostly on topic...)
    ... difference between a static IP and the runny sort? ... Can anyone recommend a simple project management package for the Mac? ... What's the most effective way of sharing my HP Officejet 5610 all-in-one ... Thanks very much indeed for any and all advice. ...
    (uk.comp.sys.mac)
  • Re: [Run Nunn] The Run Nunn Relationship Challenge 2007
    ... that's been my advice all along and I'm sticking with it. ... On the other hand, if you are to end up in a relationship of some sort, I'd ... But this isn't a good reason to take the advice, because if you did that you ... think about targeting the early-thirties single childless market, ...
    (uk.sport.football)
  • Re: Do new amp speakers need to "break in"?
    ... If so is this guitar amp ... he put his own head in a bench vice and turned it so tight he ... take ANY further advice at all from that sort of person. ...
    (alt.guitar.amps)