excel changes the word true to capital letter

D

Dan

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

Niek Otten

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top