True to TRUE

  • Thread starter Nikki@CustomMortgageSolutions
  • Start date
N

Nikki@CustomMortgageSolutions

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????
 
C

Chip Pearson

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"
in message
news:[email protected]...
 
T

TomHinkle

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.
 
T

TomHinkle

Nikki@CustomMortgageSolutions said:
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????
Click to expand...
 
Top