Format Cells in The Short Date Number Format in Excel
This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format displays the date like this: m/d/yyyy. The date is only in numbers and the month is the first number, day of month the second number, and the year represented in 4 digits is the last number.
This macro is a great piece of vba code to use when you need to format a large section of a worksheet or workbook in the Short Date number format.
Where to install the macro: Module
Macro to Format Cells in The Short Date Number Format in Excel
Sub Format_Cell_Date_Short()
Selection.NumberFormat = "m/d/yyyy"
End Sub
Subscribe for Weekly Tutorials
Helpful tutorials delivered to your email!
Similar Content on TeachExcel
Format Cells in The Long Date Number Format in Excel
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Format Cells in The General (default) Format in Excel Number Formatting
Macro: This free Excel macro formats a selected cell or range of cells to the General number form...
Macro: This free Excel macro formats a selected cell or range of cells to the General number form...
Format Cells in The Number (Numerical) Number Format in Excel
Macro: This free Excel macro formats selected cells in the Number or Numerical number format in E...
Macro: This free Excel macro formats selected cells in the Number or Numerical number format in E...
Display Numbers, Dates, & Times in the Correct Format in Excel
Tutorial: In this tutorial I am going to look at Number formatting. Number formatting allows you to ...
Tutorial: In this tutorial I am going to look at Number formatting. Number formatting allows you to ...
Find the Last Column with Data in Excel VBA
Tutorial: How to find the last column in a row that has data. This includes selecting that column or...
Tutorial: How to find the last column in a row that has data. This includes selecting that column or...
Multi-Page UserForm
Tutorial: You can have multiple tabs of data on a single UserForm and this allows you to, effectivel...
Tutorial: You can have multiple tabs of data on a single UserForm and this allows you to, effectivel...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.
