Automatically Capitalizing Day Names

One of the features built into Excel is the ability to automatically capitalize days of the week if you enter them in a cell. For instance, if you type the word "wednesday," Excel would automatically change it to "Wednesday." To control this behavior, follow these steps if you are using a version earlier than Excel 2007:

1. Choose AutoCorrect from the Tools menu. (In Excel 2003, choose AutoCorrect Options from the Tools menu.) Excel displays the AutoCorrect dialog box.
2. Make sure the AutoCorrect tab is selected. (Click here to see a related figure.)
3. Select the Capitalize Names of Days check box if you want Excel to automatically capitalize for you.
4. Clear the Capitalize Names of Days check box if you don't want Excel to make automatic changes.
5. Click on OK.

If you are using Excel 2007, then you should use these steps, instead:

1. Click the Office button, and then click Excel Options. Excel displays the Excel Options dialog box.
2. At the left side of the dialog box, click Proofing.
3. Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box.
4. Select the Capitalize Names of Days check box if you want Excel to automatically capitalize for you.
5. Clear the Capitalize Names of Days check box if you don't want Excel to make automatic changes.
6. Click on OK.