RootsChat.Com

Well done with the perseverance. I can only suggest with the sorting, make sure it's set to sort in that column lowest to highest. Have you frozen the top line? Try sorting again selecting all the rows from the bottom of the sheet and stop at row 2. Make sure the box for 'headers' is ticked/unticked accordingly.

Have you tried sorting years then the date column? If you have 2 in the same year does it sort the date column correctly. When I enter dates I get a dash between the number and month unlike in your screen grab.

Weird. I'm still using Microsoft 2007.

Doubt they would of stopped that facility.

Here's an image of my marriage tab. With so many columns you can sort by any order you like.

Highlight the column you want for day-month in the top line of your sheet i.e. 'C'

Right click and go 'Format cells' then the 'number' tag

Choose 'Custom' then scroll down till you see 'dd-mmm' and pick it.

Once you have all the months enterered you only have to type say '2 [space] F' to get 02-Feb in the column.

If you 'freeze' the top line (the column descriptions you have entered) and then select all the columns and 'custom sort' you can put everything in order by the columns you want ie. Sort by Year, then date then parish etc. Don't forget though when sorting the whole sheet you have selected all columns and tick the 'My data has headers' box (the frozen description line). If you forget a column all the lines will fail to line up and you work will be wasted. Perhaps get in the habit of saving a copy every so often that you can go back to as it is easily done!

I seem to remember once, a few years ago, seeing online the results and images of Census returns for the town of Calais, I think 1851, carried out as part of the England/Wales census. Can anyone confirm and where to look for them?