ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   excel changes the word true to capital letter (https://www.excelbanter.com/setting-up-configuration-excel/191081-excel-changes-word-true-capital-letter.html)

dan

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

Niek Otten

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




All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com