My workgroup is trying to incorporate a new acronym, HSA, into our Excel
worksheets. Every time we try, it is automatically changed to HAS. We have
added it to Custom Dictionary in Word, and it passes Word and Outlook
spellchecks just fine. The only workaround I have is to type H.S.A.

tools options spelling ..........tick "ignore words in uppercase"

regards
Bill K
"goodenplenty" <(E-Mail Removed)> wrote in message
news:03AB580A-D8CC-48F3-85C7-(E-Mail Removed)...
> My workgroup is trying to incorporate a new acronym, HSA, into our Excel
> worksheets. Every time we try, it is automatically changed to HAS. We have
> added it to Custom Dictionary in Word, and it passes Word and Outlook
> spellchecks just fine. The only workaround I have is to type H.S.A.

Hi

Have a look at Auto Correct (Tools>AutoCorrect) You'll need to remove the
correction for "hsa" which, as you've discovered, will be replaced with
"has"

"goodenplenty" <(E-Mail Removed)> wrote in message
news:03AB580A-D8CC-48F3-85C7-(E-Mail Removed)...
> My workgroup is trying to incorporate a new acronym, HSA, into our Excel
> worksheets. Every time we try, it is automatically changed to HAS. We have
> added it to Custom Dictionary in Word, and it passes Word and Outlook
> spellchecks just fine. The only workaround I have is to type H.S.A.

Either remove the correction from tools>autocorrect (type in hsa in the
replace box and press enter then click delete)
or do as I do, after you have type HSA, press space, then immediately ctrl +
z, then enter out of the cell or continue typing other stuff

Regards,

Peo Sjoblom


"goodenplenty" <(E-Mail Removed)> wrote in message
news:03AB580A-D8CC-48F3-85C7-(E-Mail Removed)...
> My workgroup is trying to incorporate a new acronym, HSA, into our Excel
> worksheets. Every time we try, it is automatically changed to HAS. We have
> added it to Custom Dictionary in Word, and it passes Word and Outlook
> spellchecks just fine. The only workaround I have is to type H.S.A.

Or in TOOLS>AUTOCORRECT creade the HSA acronym in all caps. Autocorrect is
case sensitive.


"goodenplenty" wrote:

> My workgroup is trying to incorporate a new acronym, HSA, into our Excel
> worksheets. Every time we try, it is automatically changed to HAS. We have
> added it to Custom Dictionary in Word, and it passes Word and Outlook
> spellchecks just fine. The only workaround I have is to type H.S.A.

Thanks, I had never explored autocorrect before. That answers a few oddities
I've experienced.

"bigwheel" wrote:

> Hi
>
> Have a look at Auto Correct (Tools>AutoCorrect) You'll need to remove the
> correction for "hsa" which, as you've discovered, will be replaced with
> "has"
>
> "goodenplenty" <(E-Mail Removed)> wrote in message
> news:03AB580A-D8CC-48F3-85C7-(E-Mail Removed)...
> > My workgroup is trying to incorporate a new acronym, HSA, into our Excel
> > worksheets. Every time we try, it is automatically changed to HAS. We have
> > added it to Custom Dictionary in Word, and it passes Word and Outlook
> > spellchecks just fine. The only workaround I have is to type H.S.A.
>
>
>

You could also create an AutoCorrect entry that would change lower cas
'hsa' to upper case "HSA" automatically!

Good Luc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=27026