Microsoft Office Tutorials and References
In Depth Information
Click the Number tab to display the Number page of the Format Cells dialog box.
In the Category list, click Time to display the available time formats.
In the Type pane, click 1:30 PM .
Click OK to save your changes. The Format Cells dialog box closes, and your new
style’s definition appears in the Style dialog box.
Click OK to close the Style dialog box.
Select cells C4:N4 .
On the Home tab, in the Styles group, click Cell Styles . Your new style appears at the
top of the gallery, in the Custom area.