Cannot get Sort to work.

macropod · #4 01-03-2014, 03:30 AM

Quote:

I used a Word 2010 page to build a table.
If that is not a Word Table could you please tell me what a word table is?

If you have a look at your post, there is no table as such - just multiple lines of text. Whether what you have in your document is in a table - and what its structure might be - cannot be seen from that.

Quote:

They are dates in the format that is used in England so could you please tell how I could set them out so that dates or not they will be capable of sorting?

Since when is a '23.061976' date in any country? Similarly, '1976' is not a date - it is merely a number. You might interpret it as a date, but it could just as easily be a part number. To a computer, it's nothing more than a number.

Quote:

I'm not clear as to what is a number sort. Could you please elaborate?

To understand how a number sort works, visualize your dates as not having the periods. In such a scenario, a number sort for:
02.08.1974
23.12.1974
01.05.1976
11.06.1976
18.07.1977
would return the same as:
01051976
02081974
11061976
18071977
23121974
(note the re-ordering)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
EXCEL will not sort	texascpa	Excel	6	04-17-2013 07:58 AM
Simple Excel sort did not work correctly	Spideriffic	Excel	1	09-06-2012 04:40 AM
work vs regular work. and how regular work works	user0044	Project	5	03-06-2012 07:28 AM
Sort Data	rkeles	Excel	6	02-04-2012 01:31 PM
Sort Range	boutells	Excel	1	07-15-2009 03:02 AM