changed to capital letter

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?
 
T

T. Valko

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.
 
D

Dan

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i turn all letters into capital letters? 3
Change first letter of every word to Capital 7
Turn to capital letter 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
display months (in date format) in capital letters 3
how do i change the words from lower case to uppercase/capitals 3
Sentence with first letter in Capital, rest all in small. 3
Capitalise first word in a cell 2

Top