Hi Carol If you have excel and want to set up the spread sheet best way is to use the help menu, turn on the assistant, and ask "how do I format columns Column A & B you don't have to change as default is "general" For collum C click on the C at the top of the column [the whole column will highlight] click on format and change from general to number and set decimal places to zero. You can set how many records you want to a page just ask the assistant how. If you need any further help contact me off list Anyone who does not have Microsoft office and wants to set up spread sheets etc Free software is available from www.openoffice.org It is fully compatible with latest version of Microsoft office and from a safe site. Peter O'D Central Coast

Dear Carole, Although you mention MS Excel, do you by any chance have MS Access on your computer? I only ask this because there is an amazing number of basic formats already set up which can be customised by you, to suit your needs. There are included tutorials on how to use them. I only have XP with Office 2007. I expect that Windows 7 with relevant Office programs should have even more features. I have not had to use a database since 1998 and both Excel but particularly Access now has become far more user friendly since then. Both programs seem now to talk to each other, so if you already have some data entered it can imported or exported from the original source. The Sample Print preview on Access may answer many of your questions. If you set up a sample page within Excel, likewise look at ## ALL ### the >Print Preview > Page Options >Sheet options which may help you too. Cheers, Tony Moore @@@@@@@@@@@@@@@@@@@@@@@@@@@@@ On 22 Sep 2012 at 12:53, carole douch wrote: From: "carole douch" <carole.douch@bigpond.com> To: <aus-nsw-sydney@rootsweb.com> Date sent: Sat, 22 Sep 2012 12:53:52 +1000 Subject: [ANS] excel index set up Send reply to: aus-nsw-sydney@rootsweb.com > Can any one help please. > > Im doing school index 1900, I want to have > > surname, Christian name , number, > > I want three or four sets of these on a page when printed off, in alphabet > order. > > I have windows 7 , do I set it up before I start or after I have index > finished. > > Thanks carole

Can any one help please. Im doing school index 1900, I want to have surname, Christian name , number, I want three or four sets of these on a page when printed off, in alphabet order. I have windows 7 , do I set it up before I start or after I have index finished. Thanks carole

Hi Carole, In principle, the answer to your question is that it is best to set up formats first. In the case that you've given, it should be straightforward and Peter has explained how to do it. However, in case you wish to expand the information, there is a "gotcha" in Excel that's worth noting for family historians. If all dates are 1900 or later, that's fine, but as soon as you go back to 31-Dec-1899, Excel doesn't "understand" this as a date. So for example, if you needed to add a date of birth column to your 1900 school record, you could have difficulty getting it to sort into order properly. Just something to watch out for. Best wishes, Mike Gould Leicestershire, UK -----Original Message----- From: aus-nsw-sydney-bounces@rootsweb.com [mailto:aus-nsw-sydney-bounces@rootsweb.com] On Behalf Of carole douch Sent: 22 September 2012 03:54 To: aus-nsw-sydney@rootsweb.com Subject: [ANS] excel index set up Can any one help please. Im doing school index 1900, I want to have surname, Christian name , number, I want three or four sets of these on a page when printed off, in alphabet order. I have windows 7 , do I set it up before I start or after I have index finished. Thanks carole Please remember to snip most of the earlier message before you post any reply...... Thank you! ------------------------------- To unsubscribe from the list, please send an email to AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

_____ Subject: Olive BROWN Hello List Could some kind person with access to the after 1900 births please do a check for me? I am looking for the birth of Olive May Brown. Her parents were supposed to marry about 1903 in Narrabri NSW but I can find no record of this. The parents were Samuel BROWN and Henrietta Ann GREGORY. I would be most grateful it there is anyone out there who can solve this mystery. I know Samuel was a shearer living in Dover St. Moree in 1917. Thank You Verna

Hello Verna, please contact me off line. regards Max Bancroft maxban1038@yahoo.com.au ________________________________ From: Verna Bode <misspop@bigpond.com.au> To: aus-nsw-sydney@rootsweb.com Sent: Friday, 21 September 2012 10:17 PM Subject: [ANS] FW: Olive BROWN   _____  Subject: Olive BROWN Hello List Could some kind person with access to the after 1900 births please do a check for me? I am looking for the birth of  Olive May Brown. Her parents were supposed to marry about 1903 in Narrabri NSW but I can find no record of this. The parents were Samuel BROWN and Henrietta Ann GREGORY. I would be most grateful it there is anyone out there who can solve this mystery. I know Samuel was a shearer living in Dover St. Moree in 1917. Thank You Verna Please remember to snip most of the earlier message before you post any reply...... Thank you! ------------------------------- To unsubscribe from the list, please send an email to AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Many thanks for your help Cathy. We are still hoping to find details of William's parents who may be recorded when he was enrolled at the St. James School. Peter S. ----- Original Message ----- From: "Cathy Dowie" <cathyppp@xtra.co.nz> To: <aus-nsw-sydney@rootsweb.com> Sent: Tuesday, September 18, 2012 7:21 AM Subject: Re: [ANS] William BELL. > > > If William John Bell went to St James School in the centre of Sydney > there could be a small amount of information about his being there in > an "exercise book history" > called "The Georgian School". > > It was compiled by Miss F.E.Osburne-Lilly and is in the Aus Genealogy > Society's library. > In a family tree in this ex book a Bell family are mentioned, > including Dr James Oliphant Bell who married the dau of Rev William > Ward), and his family. There is a son, William, Captain of the > family-owned ship "Cockermouth/ Cockermonth" . > > I hope this is useful > > Cathy > descendant of William Osburn and Mary > > > > On 17/09/2012, at 12:26 PM, Peter Stevens wrote: > >> Hello Listers, >> >> I am looking for information on my g/grandfather William BELL. >> According to a memorial notice he was born in Sydney on 29th. >> November 1840 and >> educated at St. James's School. >> His parents are believed to be William John BELL and Mary ?. >> I have no other records about William and his parents so I am >> hoping there may be >> a possible reference on his school records.(Unfortunately I don't >> know which St. James >> school he attended. >> I will be gratefull for any help or suggestions. > > Please remember to snip most of the earlier message before you post any > reply...... Thank you! > > ------------------------------- > To unsubscribe from the list, please send an email to > AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without > the quotes in the subject and the body of the message >

On 18/09/2012 3:39 PM, Peter STRAUSS wrote: > Does any Lister have experience with this project? I have had no experience with that ANCESTRY project. But did think seriously about the pros and cons of DNA as a genealogical tool. When we construct our "family tree" using the records of Registrars, elderly relatives, archives, libraries we depend largely upon the records of lawful marriages and lawful offspring. When we visit a recently pregnant woman in maternity hospital and see her wee new babe alongside there's no doubting that she is the mother of that babe. And the happy husband sitting there holding her hand is <probably> father of that babe. DNA science pays no regard to BDM registers. If the mother was unfaithful, or raped by another male, or.........otherwise impregnated then the eventual descendants of yesterday's new born babe could observe in their own DNA count that they had origins of an unexpected race and location. > Is it a useful genealogy tool or just a money-maker for Ancestry Yes and No. Alistair

Hi Peter There is a good overall review of ancestry DNA test here http://cruwys.blogspot.co.uk/ The new test is still in beta and not yet for sale outside the USA, so their laws apply if you purchase from them. No date on when it will be release for oversea. Karen > Does any Lister have experience with this project? > > > > Is it a useful genealogy tool or just a money-maker for Ancestry? > > > > I am interested in utilising it if I here back good reports. >

Does any Lister have experience with this project? Is it a useful genealogy tool or just a money-maker for Ancestry? I am interested in utilising it if I here back good reports. Peter Melbourne

Will do, thanks Tony Gloria

If William John Bell went to St James School in the centre of Sydney there could be a small amount of information about his being there in an "exercise book history" called "The Georgian School". It was compiled by Miss F.E.Osburne-Lilly and is in the Aus Genealogy Society's library. In a family tree in this ex book a Bell family are mentioned, including Dr James Oliphant Bell who married the dau of Rev William Ward), and his family. There is a son, William, Captain of the family-owned ship "Cockermouth/ Cockermonth" . I hope this is useful Cathy descendant of William Osburn and Mary On 17/09/2012, at 12:26 PM, Peter Stevens wrote: > Hello Listers, > > I am looking for information on my g/grandfather William BELL. > According to a memorial notice he was born in Sydney on 29th. > November 1840 and > educated at St. James's School. > His parents are believed to be William John BELL and Mary ?. > I have no other records about William and his parents so I am > hoping there may be > a possible reference on his school records.(Unfortunately I don't > know which St. James > school he attended. > I will be gratefull for any help or suggestions.

Hi Tracey Here is the link to the NSW Births Deaths and Marriages Registration Act 1995 http://www.legislation.nsw.gov.au/maintop/view/inforce/act+62+1995+cd+0+N I use this legislation site www.legislation.nsw.gov.au a lot for my work, and it is a really well organised site for viewing Acts of NSW Parliament. This particular Act has sections about corrections and access to Register etc. Regards Jill You wrote > I actually thought that under the Births Deaths and Marriages Act that the basic information (as well as for burials) was supposed to be available for free (I do know that they are held by the different states, however I thought it was a Commonwealth Act). The law I found was a little while ago and unfortuantely I can't remember where (silly me). But if I find it again I will let all know. I just think you should be entitled to basic information. Anyway that's my 20cents worth. Thanks. Tracey.

Ok, thank you anyway. Kaye www.teapotgenealogy.com ----- Original Message ----- From: "Peter Stevens" <ztevenz@bigpond.com> To: <aus-nsw-sydney@rootsweb.com> Sent: Monday, September 17, 2012 11:24 AM Subject: Re: [ANS] William BELL. > Out of luck Kaye > > He married Mary Amelia GRIMES, Brisbane, 25th.Dec. 1862. > > Janice. >

I wish to advise that I've a response from NSW BDM re what I believed were Transcription errors in their Indexes: being as some have suggested; not Transcription errors, but rather; was when the Children's Births were registered some 100 years later. It seems strange that the Children's Births were Registered some 100 years after their Births and after their Deaths as well? Again; thank you to all who took an interest in my query. Regards: Robert KEMSLEY

Out of luck Kaye He married Mary Amelia GRIMES, Brisbane, 25th.Dec. 1862. Janice. ----- Original Message ----- From: "Kaye Vernon" <kjvernon@bigpond.net.au> To: <aus-nsw-sydney@rootsweb.com> Sent: Monday, September 17, 2012 10:28 AM Subject: Re: [ANS] William BELL. > Just checking if he is the same William Bell who married Maria RAdburn in > the Carcoar area? > Kaye > www.teapotgenealogy.com > > ----- Original Message ----- > From: "Peter Stevens" <ztevenz@bigpond.com> > To: "AUS-NSW-SYDNEY" <AUS-NSW-SYDNEY@rootsweb.com> > Sent: Monday, September 17, 2012 10:26 AM > Subject: [ANS] William BELL. > > >> Hello Listers, >> >> I am looking for information on my g/grandfather William BELL. >> According to a memorial notice he was born in Sydney on 29th. November >> 1840 and >> educated at St. James's School. >> His parents are believed to be William John BELL and Mary ?. >> I > > > Please remember to snip most of the earlier message before you post any > reply...... Thank you! > > ------------------------------- > To unsubscribe from the list, please send an email to > AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without > the quotes in the subject and the body of the message >

Dear Gloria, If you haven't already done so, inform the registrar BDM, and they will hastily correct and re-issue a certificate for you. They are well aware of their imperfections and haste during a time of bereavement and try to do their best. Even though I was the informant, my sister noticed that the certificate when issued, had Mum as widower rather than widow. She contacted the BDM office retyped and re-issued the certificate and apologised profusely. Cheers, Tony Moore (Castle Hill, NSW) @@@@@@@@@@@@@@@@@@@@@@@ On 17 Sep 2012 at 10:37, Gloria wrote: From: " Gloria" <smith-thompson@bigpond.com> To: <aus-nsw-sydney@rootsweb.com> Date sent: Mon, 17 Sep 2012 10:37:59 +1000 Subject: [ANS] BDM errors Send reply to: aus-nsw-sydney@rootsweb.com > I was the informant on my late husband's death cert; I gave correct details > to the Funeral director, and yet when I received a copy of the death > certificate , there was an obvious name error and it was misspelt also. > > Gloria > > Please remember to snip most of the earlier message before you post any > reply...... Thank you! > > ------------------------------- > To unsubscribe from the list, please send an email to AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

> I actually thought that under the Births Deaths and Marriages Act that the basic information (as well as for burials) was supposed to be available for free (I do know that they are held by the different states, however I thought it was a Commonwealth Act). The law I found was a little while ago and unfortuantely I can't remember where (silly me). But if I find it again I will let all know. I just think you should be entitled to basic information. Anyway that's my 20cents worth. Thanks. Tracey. ....wrote > I love how everyone is offering to do the transcriptions for free - we > should let the Registrar know! > > > It costs in Victoria and I think in SA - not sure if anywhere else, so > that > limits the amount of general searching which you can do - no such limits > apply here in NSW.

I was the informant on my late husband's death cert; I gave correct details to the Funeral director, and yet when I received a copy of the death certificate , there was an obvious name error and it was misspelt also. Gloria

Just checking if he is the same William Bell who married Maria RAdburn in the Carcoar area? Kaye www.teapotgenealogy.com ----- Original Message ----- From: "Peter Stevens" <ztevenz@bigpond.com> To: "AUS-NSW-SYDNEY" <AUS-NSW-SYDNEY@rootsweb.com> Sent: Monday, September 17, 2012 10:26 AM Subject: [ANS] William BELL. > Hello Listers, > > I am looking for information on my g/grandfather William BELL. > According to a memorial notice he was born in Sydney on 29th. November > 1840 and > educated at St. James's School. > His parents are believed to be William John BELL and Mary ?. > I