How to Change a Date to Long Date Format

– How to Change Date Format
– How to Change a Date to Short Date Format
– How to Change a Date to Include Time

You can format the date in many different ways in Excel. The long date format is one of the popular format people like to use. The long date format is the "Month" name, Day, and the Year ("Month Day, Year"). For example, March 5, 2018, is the long date format.

Please follow the steps below to change a date to long date format:

Step 1. Select the cells with dates;

Step 2: Click the "Home" Tab from the Ribbon;

Step 3: Click the format box in the "Number" section;

Step 4: Click "Long Date" from the drop-down list;

Step 5: All selected dates will change to the Long Date.