Formatting Issues

How to Set a Long Date Format in Windows and Excel

John WilsonJohn Wilson Oct 22, 2026 869 views

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.

How to Set a Long Date Format in Windows and Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cells

Click and drag to highlight the cells containing the dates you want to reformat in your Excel worksheet.

2
Open the Format Cells dialog

Right-click the selected cells and choose 'Format Cells' from the context menu, or simply press the Ctrl+1 keyboard shortcut.

3
Choose the Date category

In the Format Cells window, navigate to the 'Number' tab and select 'Date' from the Category list on the left.

4
Select a format or create a custom one

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.

5
Apply changes

Click the 'OK' button to save and apply the new long date format to your selected spreadsheet cells.

Apply a Long Date Format in Excel Cells
Formula Bar Limitation: No matter what custom format you apply to the cell, Excel's formula bar will continue to display the underlying date in standard short format.
Advanced Spreadsheet Formatting Tool

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. 1. Open your file in WPS: Launch WPS Spreadsheet and open the document containing your date values.
  2. 2. Highlight cells: Select the specific cells or columns where you want the long date format to apply.
  3. 3. Access cell formatting: Right-click the selection and choose 'Format Cells', or press Ctrl+1 on your keyboard.
  4. 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. 5. Confirm and apply: Click 'OK'. The dates will instantly update to the long format on your worksheet.
Fully compatible with Microsoft Office formats, ensuring your .xlsx date formatting remains perfectly intact.Intuitive right-click menu and formatting panel for applying custom date codes like 'mmmm d, yyyy'.Lightweight and fast to load, offering a complete set of robust spreadsheet tools for free.
QA img-9

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.