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

Ann It would help if you let us know which version of Excel you have I used to have an old Excel. I can't remember which version it was possibly 2003. In this version there is a item on the toolbar called 'autotext' this automatically corrects any text you in put. I think this is what is happening in your case. You can check the auto text list and delete those you don't want auto correcting. I now have Excel 2010 and have this auto text. Mind you I do miss it at times as I used to just put my initials on and this changes to my full name. Maybe I still have it so will check when I get home Victor Sent from my BlackBerry® wireless device -----Original Message----- From: "Anne Cole" <duncalf@one-name.org> Sender: eng-lincsgen-bounces@rootsweb.com Date: Sat, 24 Mar 2012 12:25:51 To: <eng-lincsgen@rootsweb.com> Reply-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

Hi Anne Go to Tools- Options - Spelling - Auto Correct options - Autocorrect - and remove tick from box - "Replace text as you type " Regards Tony ----- Original Message ----- From: "Anne Cole" <duncalf@one-name.org> To: <eng-lincsgen@rootsweb.com> Sent: Saturday, March 24, 2012 12:25 PM 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 >

I have always used a full stop when excel does its own thing . Ie BALANCE. - worth a try Dan ----- Original Message ----- From: "Anne Cole" <duncalf@one-name.org> To: <eng-lincsgen@rootsweb.com> Sent: Saturday, March 24, 2012 12:25 PM 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