View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] danyates77@yahoo.com is offline
external usenet poster
 
Posts: 3
Default 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