Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy excel cell to cell in word table using excel macro jthurnwps Excel Discussion (Misc queries) 0 July 21st 06 07:11 PM
Insert rows (1 to 4) if the cell value equals a fixed word Joy Excel Discussion (Misc queries) 1 July 20th 06 08:40 AM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
in an excel macro can you import data from word into a cell? Trefor Excel Discussion (Misc queries) 11 October 6th 05 01:49 PM
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"