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