Add word in cell changes to word TRUE

[Guest]

Hello,

I know that the words TRUE and FALSE are used for formating data but I am
trying to do a spelling list with the word true and after typing the word in
the cell, it automatically centers and capitalizes.

I've checked the format option.

Any ideas?

Thanks

 

[danyates77]

try 'TRUE with a ' in front of the TRUE. That'll make it text instead
of the excel value TRUE. The ' won't show up in the list, so it will
still look like the word TRUE for your spelling list.

 

[Paul B]

Joey, format the cell as text first and then put in the words or put a ' in
front of the words, the ' will not show

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Got it! Changed the format to Text rather than General!