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

---