Export (0) Print
Expand All

Date Format Dialog Box

SQL Server 2012

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft