Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 115
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! [email protected] Excel Discussion (Misc queries) 3 January 5th 07 02:18 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"