By Allen Wyatt for Excel.Tips.Net
Automatically Capitalizing Day Names in Microsoft Excel
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:
1.Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 display the File tab of the ribbon and click Options.)
2.At the left side of the dialog box, click Proofing.
3.Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box. (See Figure 1.)