How to Apply the March 14 2012 Date Number Format
You can customize this format in the last step below. The date will displayed using the format mdyy Apply the Percentage number format with zero decimal places to the range G5G11 to clarify the range contains percentage values. Pin On Web Apps Programming In EXCEL I format cells with Home numberdropdown then date Mar-12 or mmm-yy. . Select Short Date from the drop-down list. Note that the characters that can be used in date formats are described in Table 1 below. Using the Format Cells Dialog Box to Apply Short Date Format in Excel. Your format will preview in the Sample box with the first date in your data. Or if you have a column of dates you can specify that you want the dates to appear as March 14 2012 14-Mar-12 or 314. Formatting cells with number date Mar-12 or mmm-yy. Date formats that begin with an asterisk will change if you change the regional date and time settings in Control Panel. Use AutoFill...