Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anyone has ideas on how I could keep the value of a cell stay as
ALL... Currently, it is interpreting it as ALL? Thanks! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can check your auto correct settings. Tools - Options - Spelling -
Auto Correct -- HTH... Jim Thomlinson "rambino" wrote: Anyone has ideas on how I could keep the value of a cell stay as ALL... Currently, it is interpreting it as ALL? Thanks! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have a look at Tools, Options, Spelling, AutoCorrect Options.
RBS "rambino" wrote in message ... Anyone has ideas on how I could keep the value of a cell stay as ALL... Currently, it is interpreting it as ALL? Thanks! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It seems when Excel encounters "..." it 'auto-corrects' it with the elipsis
character (#133 in the ANSI character table. See - http://www.handheld-basic.com/docume...page_599.html). Perhaps the font that you have selected does not support the display of that character. To change the Auto Correct options, go to Tools-AutoCorrect Options. -- Hope that helps. Vergel Adriano "rambino" wrote: Anyone has ideas on how I could keep the value of a cell stay as ALL... Currently, it is interpreting it as ALL? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |