True=TRUE

J

jason

every time i key "true" i get "TRUE" this happens on all
PC that a have tred this on. Why? and can i fixs it?
 
G

Guest

-----Original Message-----
every time i key "true" i get "TRUE" this happens on all
PC that a have tred this on. Why? and can i fixs it?
.
Click to expand...
=======

Try
'true
 
J

jason

the ' true works why, why did it do this. It is NOT
format it happens on all excel worksheets i have tried
this on and I go into "Format" and "Lock" and all that
good stuff but know change.
 
H

Harald Staff

TRUE and FALSE are distinct boolean values that Excel understands and can
calculate with. Like if you enter 5 then Excel assumes that you want the
numeric value 5 and not the character 5. A qualified guess, and the outcome
of guesses are sometimes not what the user wants.

But why on earth would any user want a spreadsheet cell saying true ? It's
not even a boolean value, just four letters lining up. Word stuff.

HTH. Best wishes Harald
 
Top