Select the cell you want to modify.
On the Home tab, click Cell, and then click Alphanumeric.
Normal: Sets format to allow a mix of capitals and lower case.
Upper: Sets format as all uppercase
Lower: Sets format as all lowercase
Click OK.
Tip: Capitalization may be changed for date cells as well. On the Home tab, in the Content group, click Cell and then click Date.