Knowledge Base

XL98: AutoCorrect May Not Capitalize the First Word in a Sentence

Article ID: 184377

Article Last Modified on 9/11/2002


APPLIES TO


This article was previously published under Q184377

SYMPTOMS

If you enter a sentence in a cell, the AutoCorrect feature may not capitalize the first word in the sentence. This behavior may occur even if you have selected the "Capitalize first letter of sentence" check box in the AutoCorrect dialog box.

CAUSE

The problem occurs when you enter a single sentence in a cell and the first letter of the first word is not capitalized. The AutoCorrect feature only capitalizes the first letter in the first word of a sentence if you precede this word with a period that is followed by a space. Note, if you type multiple sentences in a cell, the first words in the second and subsequent sentences are capitalized by the AutoCorrect feature if you end these sentences with a period that is followed by a space.

The first word of the first sentence in a cell is not capitalized by the AutoCorrect feature. To capitalize the first word of the first sentence, you must edit the sentence in the cell.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

The AutoCorrect feature in Microsoft Excel automatically corrects text as you type. It offers the ability to correct the following:

  • words that begin with two capital letters
  • sentences in which the first word is not capitalized
  • days of the week that are not capitalized
  • accidental use of the CAPS key
  • words that you commonly misspell
Each of these options can be turned on or off in the AutoCorrect dialog box. To display the AutoCorrect dialog box, click AutoCorrect on the Tools menu.

REFERENCES

For more information about AutoCorrect, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

autocorrect

and then click Show Topics. Select the "Check spelling or automatically correct spelling errors" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: auto correct XL98 proper

Keywords: kbbug kbualink97 kbpending KB184377