Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Why does the word typed "true" automatically turn to ALL CAPS?

Why does the word typed "true" automatically turn to ALL CAPS?
Also why does a foder named "con" cannot be created in Office?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 634
Default Why does the word typed "true" automatically turn to ALL CAPS?

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,688
Default Why does the word typed "true" automatically turn to ALL CAPS?

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
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
can I turn off the memory carry-over from previously typed cells Mpski5 Excel Worksheet Functions 8 May 17th 05 08:35 PM
Why does Excel automatically create a temporary Word archive file. Perplexed Excel Discussion (Misc queries) 3 March 1st 05 07:26 PM
making columns automatically turn numbers into negatives Kathy Excel Worksheet Functions 6 February 1st 05 06:23 AM
Negative numbers turn positive automatically on data entry Jerri Excel Discussion (Misc queries) 4 January 8th 05 06:05 PM
Excel merged cell - can it automatically expand as text is typed? Joanne (JAS) New Users to Excel 2 January 8th 05 01:11 AM


All times are GMT +1. The time now is 11:59 AM.

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

About Us

"It's about Microsoft Excel"