Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy excel cell to cell in word table using excel macro | Excel Discussion (Misc queries) | |||
Insert rows (1 to 4) if the cell value equals a fixed word | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) |