TRUE: Would like it to appear as "True" in the cell.

  • Thread starter Thread starter Lindsay
  • Start date Start date
L

Lindsay

Using Microsoft Excel 2007.

I am typing in a name 'True', but when I type the name it is capitalizing
the entire word 'TRUE'. I would like to capitalize only the first letter in
the name.

How do I achieve this using Excel? I believe Excel recognizes it as a formula.
 
Either:
format the cell to Text prior to entry
or:
precede the value with an apostophe (single quote)
 
In Excel TRUE and FALSE are special values. They're called Boolean values or
logical values. They *are not text* entries. Excel makes it easy to spot the
difference by displaying the Booleans in all UPPERCASE and centered in the
cell.

To enter a *text* string True or False precede the entry with an apostrophe
like this: 'True, 'False. The apostrophe will not be displayed in the cell.
The apostrophe tells Excel that you want that entry to be explicitly
evaluated as a text string.
 
Back
Top