changed to capital letter

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

when I type the word true in small letters and hit the enter key excel
automatically changes it to capital letterTRUE
does anybody know why?
do I need to do something in the options set up?
 
Both TRUE and FALSE have a special meaning in Excel. These are called
logical values (often referred to as Boolean values). These *are not TEXT
values*.

If you want to enter true as a TEXT value precede the entry with an
apostrophe: 'true

The apostrophe will not be displayed in the cell.
 
it's working
thank you

T. Valko said:
Both TRUE and FALSE have a special meaning in Excel. These are called
logical values (often referred to as Boolean values). These *are not TEXT
values*.

If you want to enter true as a TEXT value precede the entry with an
apostrophe: 'true

The apostrophe will not be displayed in the cell.
Click to expand...
 
Back
Top