Why does Excel 2007 changes the text "HSA"to "HAS"?

Question

Working on Excel 2007 I am trying to populate a cell with the text HSA. However, when pressing enter, the text changes automatically to HAS.

I assume there is a kind of auto spelling correction here, but I can't find how to disable it (and, preferably, only at this cell).

KCotreau · Accepted Answer · 2011-07-17T01:12:02.893

24

I would remove that auto-correct word from the list like this:

Office Button > Excel Options > Proofing > Autocorrect Options and scroll down in the list until you get to "hsa", highlight it, and click delete.

You can't really disable it at a cell, but you can at least disable it for that one word you are having trouble with. You can always add it back again later.

enter image description here

edited Jul 17 '11 at 01:12

answered Jul 17 '11 at 00:39

KCotreau

25,622

score 7 · Answer 2 · answered Jul 17 '11 at 00:41

7

File -> Options -> Proofing -> "AutoCorrect Options" button -> "AutoCorrect" tab.

It has hsa -> has correction rule. Remove it.

P.S. The path is for Office 2010, but should be the same for 2007.

answered Jul 17 '11 at 00:41

LazyOne

516

score 3 · Answer 3 · answered Feb 02 '16 at 12:00

While cell is in edit mode, select text (in the cell or in the type bar), just after you typed it, and then press Enter. This doesn't make any auto correction at all, so you do not have neither to delete anything in your auto correct list nor disable auto correction. Not even have to add space, which may have unwanted results later.

score 1 · Answer 4 · edited Feb 04 '19 at 16:39

1

I did the following workaround as I dont want to loose the Autocorrect option.

Windows Key+R -> to open the Run dialog.
Type HSA.
Cut the whole string.
Paste it into the Excel cell.

edited Feb 04 '19 at 16:39

Doug Deden

2,204
1
12
16

answered Feb 04 '19 at 14:41

Giridharan

11

score 1 · Answer 5 · edited Oct 18 '12 at 14:19

1

Another quick workaround is to use a formula like this: ="HSA"

edited Oct 18 '12 at 14:19

Indrek

24,874

answered Oct 18 '12 at 13:56

JJS

11
1

score 1 · Answer 6 · answered Jun 11 '15 at 20:32

I was having the same problem and found a simple fix!

This person's example was for the word CNA changing to CAN.

"If you type CNA followed by a space, it is turned into CAN. Press Ctrl+Z before doing anything else to undo this change, then type on."

score 0 · Answer 7 · answered Dec 30 '14 at 02:08

Use a single quote (') at the beginning of the cell contents, as in

'HSA

in order to use the cell contents as-is without being reinterpreted or corrected by Excel. This is also good when you type in numbers that you want to be treated as text, so that Excel doesn't autoformat them with decimals, as dates, or use right-alignment.

score -1 · Answer 8 · answered Jul 16 '17 at 19:09

-1

didn't work unteaching the spell check as has or HAS wasn't there to unfix. So I taught spell check to make HAS into HSA. that worked.

answered Jul 16 '17 at 19:09

Mary Lee Kemper

1

Why does Excel 2007 changes the text "HSA"to "HAS"?

8 Answers8