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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Changing Text To Numbers ? 1
Disable autoformat of "true" and "false" text 5
Changing color of selected cells in Excel 2007 1
One Click = Multiple Cells in Excel 2007 2
Excel How to get output of the formula instead of True or false 1
Howdy! Need a little help with code... 3
Running SPSS-Syntax using Excel VBA (Excel 2013) 0

Back
Top