Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Why does the word typed "true" automatically turn to ALL CAPS?
Also why does a foder named "con" cannot be created in Office? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Because it is interpreted as being part of a TRUE/FALSE test as opposed to
simply a piece of text. As for the folder, I'm guessing it is simply a special/reserved name for a hidden Windoiws folder, or something like that. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "sunil" wrote: Why does the word typed "true" automatically turn to ALL CAPS? Also why does a foder named "con" cannot be created in Office? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Why does the word typed "true" automatically turn to ALL CAPS?
Because it's a special value. The same thing will happen when you type in "false". They will not only be in all caps but they will also be automatically centered in the cell. These are called boolean or logical values. To enter the TEXT value: true Either preformat the cell as TEXT or precede the entry with an apostrophe: 'true. Here's an obscure bit of info: If you need to count the number of TEXT entries of "true": =COUNTIF(A1:A10,"*true") A TEXT entry of true will not be counted in: =COUNTIF(A1:A10,"true") Because Excel thinks it's a boolean but at the same time: =COUNTIF(A1:A10,TRUE) Will also not count the TEXT value "true". Kind of strange! Using the wildcard coerces the argument to be evaluated as TEXT and not a boolean. Biff "sunil" wrote in message ... Why does the word typed "true" automatically turn to ALL CAPS? Also why does a foder named "con" cannot be created in Office? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can I turn off the memory carry-over from previously typed cells | Excel Worksheet Functions | |||
Why does Excel automatically create a temporary Word archive file. | Excel Discussion (Misc queries) | |||
making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |