True to TRUE
 

I'm entering data for a database at work and when I type in the last name
"True" Excel is changing it to "TRUE." I try to just undo it and it won't.
How do I make it so it's just True????

TRUE is a special value in Excel. To enter True, precede the text
with an apostrophe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nikki@CustomMortgageSolutions"
ft.com wrote
in message
...
I'm entering data for a database at work and when I type in the
last name
"True" Excel is changing it to "TRUE." I try to just undo it
and it won't.
How do I make it so it's just True????

or set the Cell you're typing in (or row or column) format to text

Excel is seeing true as a boolean value.

Chip's solution is equally correct.

"Chip Pearson" wrote:

TRUE is a special value in Excel. To enter True, precede the text
with an apostrophe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nikki@CustomMortgageSolutions"
ft.com wrote
in message
...
I'm entering data for a database at work and when I type in the
last name
"True" Excel is changing it to "TRUE." I try to just undo it
and it won't.
How do I make it so it's just True????

"Nikki@CustomMortgageSolutions" wrote:

I'm entering data for a database at work and when I type in the last name
"True" Excel is changing it to "TRUE." I try to just undo it and it won't.
How do I make it so it's just True????