Having covered font formats including the use of Excel Styles and Themes and the formatting of numbers in the first two parts of this formatting series, in this concluding part we will look at the formatting of dates and times and miscellaneous entries, explains Simon Hurst.
What standard date and time formats are available?
The list of Categories on the number tab of the Format Cells dialog includes ‘Dates’ and ‘Times’. Of the list of possible date and time formats, those preceded by an asterisk are affected by the Control Panel, Regional and Language settings. We will look at the date formats here, but the time formats work in the same way: