Thursday, February 11, 2010

How do you keep excel from changing False to FALSE in all caps it does it everytime i type it in a box?

put an apostraphe before the word (it wont show but it will tell excel its not a formulaHow do you keep excel from changing False to FALSE in all caps it does it everytime i type it in a box?
Put a single apostrophe (') before the word. It won't display the apostrophe, but tells Excel that the information is just text, not an equation, sum, or data, and so won't change the text.

No comments:

Post a Comment