Date Format Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

The Date Format dialog box provides additional date formats that you can apply to columns that have a Date data type. To access this dialog box, the PowerPivot window must be open. You must select a cell that contains a Date value. On Home, in Formatting, click the down arrow by Format, and click More Date Formats. The format you choose will be applied to all values in the column.

  • Format
    Provides a visual example of the date format string.

  • Format String
    Shows the underlying format string in date and time format specifiers, such as Y (Year), M (Month), D (Day), H (Hour), S (Second). The format string determines the text representation of the date or time value in the workbook.