Put an apostrophe in front of BALLANCE - the apostrophe will not be visible when you leave the cell. Linda -----Original Message----- From: Anne Cole Sent: Saturday, March 24, 2012 12:25 PM To: eng-lincsgen@rootsweb.com Subject: [LIN] Problem Can someone please help me? I am typing marriages into Excel, and have the surname BALLANCE. Every time I enter the name it changes it to "BALANCE". How do I get it to stay as I have put it? I have already changed the format to "Text". Anne Anne Cole, President, Lincolnshire Family History Society Duncalf(e)/Duncuff/Duncuft One-name Study GOONS member 513 http://www.one-name.org/profiles/duncalf.html Lincolnshire Post 1837 Marriage Index http://mi.lincolnshiremarriages.org.uk/ Lincolnshire Family History Society http://www.lincolnshirefhs.org.uk ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

That is one way of doing it. I used to do that all the time when I was working. If memory serves me right doing that moves the word to the right of the cell. Meaning if Ann wanted the name in the centre it won't work. Like I said this was from memory and I haven't done this for about 10 years Victor Sent from my BlackBerry® wireless device -----Original Message----- From: "Ward Family Tree" <WardFamilyTree@btinternet.com> Sender: eng-lincsgen-bounces@rootsweb.com Date: Sat, 24 Mar 2012 12:38:02 To: <eng-lincsgen@rootsweb.com> Reply-To: eng-lincsgen@rootsweb.com Subject: Re: [LIN] Problem Put an apostrophe in front of BALLANCE - the apostrophe will not be visible when you leave the cell. Linda -----Original Message----- From: Anne Cole Sent: Saturday, March 24, 2012 12:25 PM To: eng-lincsgen@rootsweb.com Subject: [LIN] Problem Can someone please help me? I am typing marriages into Excel, and have the surname BALLANCE. Every time I enter the name it changes it to "BALANCE". How do I get it to stay as I have put it? I have already changed the format to "Text". Anne Anne Cole, President, Lincolnshire Family History Society Duncalf(e)/Duncuff/Duncuft One-name Study GOONS member 513 http://www.one-name.org/profiles/duncalf.html Lincolnshire Post 1837 Marriage Index http://mi.lincolnshiremarriages.org.uk/ Lincolnshire Family History Society http://www.lincolnshirefhs.org.uk ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

This method is really for entering numerals into a cell as text and automatically moves the contents to the left of the cell - the text/numbers or whatever can be centred and it can also be sorted without interfering with normal sorting rules (I tested it before offering as a possible solution). The advantage of this method is that it can applied to a single cell or to a range of cells only and is not applied to the whole spreadsheet when it may be advantageous to retain auto text functionality. Linda. -----Original Message----- From: victor@markham.me.uk Sent: Saturday, March 24, 2012 12:47 PM To: eng-lincsgen@rootsweb.com Subject: Re: [LIN] Problem That is one way of doing it. I used to do that all the time when I was working. If memory serves me right doing that moves the word to the right of the cell. Meaning if Ann wanted the name in the centre it won't work. Like I said this was from memory and I haven't done this for about 10 years Victor Sent from my BlackBerry® wireless device -----Original Message----- From: "Ward Family Tree" <WardFamilyTree@btinternet.com> Sender: eng-lincsgen-bounces@rootsweb.com Date: Sat, 24 Mar 2012 12:38:02 To: <eng-lincsgen@rootsweb.com> Reply-To: eng-lincsgen@rootsweb.com Subject: Re: [LIN] Problem Put an apostrophe in front of BALLANCE - the apostrophe will not be visible when you leave the cell. Linda -----Original Message----- From: Anne Cole Sent: Saturday, March 24, 2012 12:25 PM To: eng-lincsgen@rootsweb.com Subject: [LIN] Problem Can someone please help me? I am typing marriages into Excel, and have the surname BALLANCE. Every time I enter the name it changes it to "BALANCE". How do I get it to stay as I have put it? I have already changed the format to "Text". Anne Anne Cole, President, Lincolnshire Family History Society Duncalf(e)/Duncuff/Duncuft One-name Study GOONS member 513 http://www.one-name.org/profiles/duncalf.html Lincolnshire Post 1837 Marriage Index http://mi.lincolnshiremarriages.org.uk/ Lincolnshire Family History Society http://www.lincolnshirefhs.org.uk ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to ENG-LINCSGEN-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

MGC: Putting the apostrophe in only works with numbers. This is not the shortest method, but at least it does work, and you don't have to change any other settings !!! Do exactly the following: In Excel, type BALLANCE Do not press enter yet. Your cursor is flashing at the end of the word BALLANCE. Press shift and Home keys together to highlight the word BALLANCE. Press control key and C key together as though you are to copy the letters BALLANCE. Now just press the enter key. Cheers - SKM. ====================== -----Original Message----- From: Ward Family Tree Sent: Saturday, March 24, 2012 2:38 PM To: eng-lincsgen@rootsweb.com Subject: Re: [LIN] Problem Put an apostrophe in front of BALLANCE - the apostrophe will not be visible when you leave the cell. Linda ======================

Let's drop this software issue and get back to your family history questions.     Lou (list admin.)