How to enter "Withe" in an EXCEL cell? Excel stores only "With".

[SeanMc98]

Attempt to enter "Withe" in a cell results in "With". Entry of "Wither" (or
any other character after the "Withe") yields "Wither" (or whatever character
was selected to follow "Withe").

Any ideas?

 

[Kevin B]

Click TOOLS in the meny & select AUTOCORRECT OPTIONS. If necessary click the
AUTOCORRECT tab. In the replace combo box, type the entry that keeps getting
corrected, Withe and it should display the replaced value for that entry.
You can either click the DELETE command button, or set the replacement text
to the same value.

When done, click OK to return to the workbook.

 

[Chip Pearson]

There is an Auto Correct entry that will change Withe to With. On the Tools
menu, select Auto Correct Options and remove that item from the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Bob I]

Check your "AutoCorrect" entries.

 

[James Silverton]

Chip wrote on Wed, 5 Sep 2007 16:06:23 -0500:

CP> There is an Auto Correct entry that will change Withe to
CP> With. On the Tools menu, select Auto Correct Options and
CP> remove that item from the list.

CP> --
CP> Cordially,
CP> Chip Pearson
CP> Microsoft MVP - Excel
CP> Pearson Software Consulting
CP> www.cpearson.com
CP> (email on the web site)

CP> message
??>> Attempt to enter "Withe" in a cell results in "With".
??>> Entry of "Wither" (or any other character after the
??>> "Withe") yields "Wither" (or whatever character was
??>> selected to follow "Withe").

If it is just an occasional "withe", space out once from the
"e" and enter CTRL-Z. This is standard autocorrect cancellation
but has to done this way in Excel 2002.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not