Typing "true" excel 2007 change it to "TRUE"

G

Guest

When I typing "true" in Excel 2007 in any cell, Excel will automatic display
as "TRUE" and align centre in the cell.

Is this bug, by design, or just my local configuration?
 
G

Guest

Excel will interpret this as a boolean statement and capitalise it. If you
want it to reamain lower case type 'true you won't see the apostrophe.

Mike
 

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

TRUE: Would like it to appear as "True" in the cell. 2
Get #### when typing 2
Howdy! Need a little help with code... 3
Changing color of selected cells in Excel 2007 1
Changing Text To Numbers ? 1
How do I stop Excel from changing the word true to TRUE? 1
Disable autoformat of "true" and "false" text 5
Excel How to get output of the formula instead of True or false 1

Top