Hi. I am working on a VERY simple spreadsheet at work (think is Excel 2007 but am not at work at the moment to double check) where I need to sort the data by UK postcode (first part only, ie GU34) THEN by date (oldest to newest). When I attempt to do this, it seems to sort the postcode part OK, but then cannot sort the dates correctly! The cells with dates are formatted at "dates" but I keep ending up with older dates occuring after newer dates. Surely sorting data in this way is not beyond the capabilities of Excel?!

Any help appreciated!