True=TRUE

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

 

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

=======

Try
'true

 

[Don]

Format to text

 

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

 

[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