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.