| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format minuscule word in capital letter one in excell? | Excel Discussion (Misc queries) | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing the word true to TRUE? | Excel Discussion (Misc queries) | |||
| how do I convert text in excel to 1st letter capital,only | Excel Worksheet Functions | |||
Linear Mode
