Add word in cell changes to word TRUE
 

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
--
Very Thankful

Add word in cell changes to word TRUE
 

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.

Joey041 wrote:
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
--
Very Thankful

Add word in cell changes to word TRUE
 

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

"Joey041" wrote in message
...
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
--
Very Thankful

Add word in cell changes to word TRUE
 

Got it! Changed the format to Text rather than General!
--
Very Thankful


"Joey041" wrote:

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
--
Very Thankful