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.
Sub Format_Cell_Date_Short()
Selection.NumberFormat = "m/d/yyyy"
End Sub