I am trying to type the name "True" in a cell and it keeps turning it into a function "TRUE" and I cannot turn off the autoformatting no matter what I try. Help!

link|improve this question
feedback

1 Answer

The traditional way to force Excel to treat an entry as text is to start with an apostrophe so try entering:

'True

link|improve this answer
Thank you so much, that worked. – Mitzie Feb 23 '11 at 16:47
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.