excel changes the word true to capital letter

  • Thread starter Thread starter Dan
  • Start date Start date
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
 
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

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
How to change cases from small to capital in all cells? 3
TRUE: Would like it to appear as "True" in the cell. 2
changed to capital letter 3
Capitalize first letter of each word 3
Change the color of each capital letter in a rich text memo field. 0
Finding two adjacent (wildcard) capital letters in MS Word? 1
Outlook Express not capitalizing 4

Back
Top