Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 08, 04:18 AM posted to microsoft.public.excel.setup
dan dan is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 866
Default excel changes the word true to capital letter

when I type the word true excel is changing it to capital letter automatically.
how can I fix the problem?
please help thank you

  #2   Report Post  
Old June 13th 08, 10:02 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default excel changes the word true to capital letter

Excel HELP explains that entering TRUE in a cell is equivalent to using the TRUE() function. Excel always changes keywords to
capitals, so it does that for true as well.
If you need just the word true in a cell, precede it by a apostrophe; that will not show in the cell. Or precede by a space, or
format the cell as text before entering the word.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| when I type the word true excel is changing it to capital letter automatically.
| how can I fix the problem?
| please help thank you




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
How do I format minuscule word in capital letter one in excell? Renato Silvio Excel Discussion (Misc queries) 1 October 11th 06 07:27 PM
New Validation option to format 1st letter as Capital letter Jeff Excel Discussion (Misc queries) 5 July 13th 06 05:11 AM
Default Capital letter for 1st letter of a word Jeff Excel Discussion (Misc queries) 6 July 10th 06 08:36 AM
How do I stop Excel from changing the word true to TRUE? Schmyerlou Excel Discussion (Misc queries) 1 November 23rd 05 08:54 PM
how do I convert text in excel to 1st letter capital,only jmfp Excel Worksheet Functions 1 June 16th 05 08:11 PM


All times are GMT +1. The time now is 04:09 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017