ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to enter "Withe" in an EXCEL cell? Excel stores only "With". (https://www.excelbanter.com/excel-discussion-misc-queries/157159-how-enter-withe-excel-cell-excel-stores-only.html)

SeanMc98

How to enter "Withe" in an EXCEL cell? Excel stores only "With".
 
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

How to enter "Withe" in an EXCEL cell? Excel stores only "With".
 
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.
--
Kevin Backmann


"SeanMc98" wrote:

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?


Chip Pearson

How to enter "Withe" in an EXCEL cell? Excel stores only "With".
 
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)


"SeanMc98" wrote in 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").

Any ideas?



Bob I

How to enter "Withe" in an EXCEL cell? Excel stores only "With".
 
Check your "AutoCorrect" entries.

SeanMc98 wrote:
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?



James Silverton[_2_]

How to enter "Withe" in an EXCEL cell? Excel stores only "With".
 
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 "SeanMc98" wrote in
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



All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com