Format Cells in The Long Date Number Format in Excel

This free Excel macro formats a selection of cells in the Long Date number format in Excel. The Long Date number format displays the day of week, the month, the day of month, and the year. This Excel macro is a great way to quickly add this number format to a large number of cells in Excel.

This macro will add the Long Date number format to cells in Excel.

Where to install the macro:  Module

Macro to Format Cells in The Long Date Format in Excel

Sub Format_Cell_Date_Long()

Selection.NumberFormat = "[$-F800]dddd, mmmm dd, yyyy"

End Sub

---