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