TRUE: Would like it to appear as "True" in the cell.
Either:
format the cell to Text prior to entry
or:
precede the value with an apostophe (single quote)
--
Gary''s Student - gsnu201001
"Lindsay" wrote:
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.
|