How to Set a Long Date Format in Windows and Excel
Question details
The user wants to configure Microsoft applications and the Windows operating system to display dates in a fully spelled-out long format, such as June 13, 2023.

- Product
- Microsoft Excel, Windows
- Device & OS
- Windows
- Scenario
- Formatting dates for formal reports, spreadsheets, or system-wide display where standard short dates are not suitable.
- Observed behavior
- Dates are currently displayed in a short numeric format by default and need to be converted to a long text format.
Keep in mind that while you can freely change the date format displayed inside Excel spreadsheet cells, the Excel formula bar will always show the date in the standard short format.
Apply a Long Date Format in Excel Cells
Use the Format Cells feature in Microsoft Excel to apply a pre-set long date or a specific custom date format to selected cells.
This method changes the visual presentation of the date on your spreadsheet without altering the underlying data. It is ideal for formalizing data presentation.
Click and drag to highlight the cells containing the dates you want to reformat in your Excel worksheet.
Right-click the selected cells and choose 'Format Cells' from the context menu, or simply press the Ctrl+1 keyboard shortcut.
In the Format Cells window, navigate to the 'Number' tab and select 'Date' from the Category list on the left.
Choose a long date format from the Type list. Alternatively, select 'Custom' from the Category list and type 'mmmm d, yyyy' into the Type box to force a specific long text format.
Click the 'OK' button to save and apply the new long date format to your selected spreadsheet cells.

Change the System-Wide Long Date Format in Windows
Modify Windows Regional settings to change the default long date format for all applications that rely on system settings.
Easily Format Dates with WPS Spreadsheet
WPS Spreadsheet provides a highly intuitive interface for customizing date formats. Whether you need standard short dates or complex custom long formats, you can configure them seamlessly with full Microsoft Excel compatibility.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open the document containing your date values.
- 2. Highlight cells: Select the specific cells or columns where you want the long date format to apply.
- 3. Access cell formatting: Right-click the selection and choose 'Format Cells', or press Ctrl+1 on your keyboard.
- 4. Set the custom date code: Go to the 'Custom' category under the Number tab and enter 'mmmm d, yyyy' in the input field.
- 5. Confirm and apply: Click 'OK'. The dates will instantly update to the long format on your worksheet.

Frequently Asked Questions
Why does the date still look like a short date in the Excel formula bar?
Excel is hardcoded to display the underlying value of a date cell in your system's default short format within the formula bar. Changing the cell format only alters the visual presentation on the worksheet, not the raw data view in the formula bar.
What is the specific custom format code to get a date like 'June 13, 2023'?
To achieve this exact format, use the custom code 'mmmm d, yyyy'. In this code, 'mmmm' spells out the full month name, 'd' displays the day of the month without a leading zero, and 'yyyy' shows the full four-digit year.
Will changing my Windows regional date format affect all my existing Excel files?
Yes, if your Excel cells are formatted using the default system date formats (which are indicated by an asterisk * in the Format Cells dialog), changing the Windows regional settings will automatically update the visual display of those dates across all your workbooks.




