Formatting Issues

Fix Excel Showing Wrong Date Format (Oct-23 Instead of Oct 24)

Phi Hung Vo Oct 21, 2026 868 views

Question details

Excel displays a date differently than entered, automatically altering the format to show the month and year instead of the month and specific day.

How to Fix Excel Showing the Wrong Date Format

Product: Microsoft Excel
Device & OS: not provided
Scenario: Typing a specific date into a cell where the exact day needs to be visible, but the software reformats it visually.
Observed behavior: The cell displays a format like 'Oct-23' (Month and Year) despite the formula bar displaying the complete and correct date (e.g., October 24, 2023).

Before you start

Click on the affected cell and check the formula bar at the top of your workspace to confirm that the correct underlying date is still properly stored before altering any display formats.

Solution 1Recommended

Adjust Custom Cell Formatting to Show the Exact Day

By modifying the cell's custom number format settings, you can force the spreadsheet to display the exact month and day you originally entered.

Excel sometimes applies default date formats based on system regional settings or its own auto-formatting rules. When a cell shows 'Oct-23' instead of 'Oct 24', the cell is actively using a Month-Year ('MMM-YY') display code.

This is purely a visual formatting issue. The actual data remains unchanged and can easily be restored visually by selecting a day-inclusive format.

Select the target cells

Click on the specific cell or highlight the entire range of cells that are displaying the incorrect date format.

Open the Format Cells dialog

Right-click the highlighted area and select 'Format Cells' from the context menu, or simply press 'Ctrl + 1' on your keyboard.

Apply a Custom Date format

Navigate to the 'Number' tab. Choose 'Custom' from the Category list on the left side. In the 'Type' text box, delete the existing text and enter 'MMM DD' (or your preferred format, such as 'DD/MM/YYYY').

Save the changes

Click 'OK' at the bottom of the dialog box to immediately apply the new display format to your selected cells.

Adjust Custom Cell Formatting to Show the Exact Day

Formatting Multiple Cells: You can select an entire column by clicking the column letter at the top, then apply this custom date format to ensure all future dates in that column display correctly.

WPS Spreadsheet Solution

Easily Fix Date Formatting Issues in WPS Office

WPS Spreadsheet provides identical custom cell formatting features to Microsoft Excel, letting you quickly correct date displays while keeping your data perfectly intact.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing the improperly formatted dates.
2. Select and right-click the cells: Highlight the affected cells, right-click them, and choose 'Format Cells' from the menu (or press Ctrl+1).
3. Set the Custom Date code: Go to the 'Number' tab, select 'Custom', and type 'MMM DD' into the formatting box.
4. Apply the format: Click 'OK' to instantly update how your dates are displayed across the selected range.

Fully compatible with Microsoft Excel (.xlsx) date and time formatsIntuitive cell formatting dialog for easy custom code entryFree, lightweight, and fast spreadsheet processing for any device

Frequently Asked Questions

Why does Excel automatically change my entered date?

Excel has built-in auto-formatting rules designed to recognize dates. If it detects a pattern that matches its default date formats, it automatically applies that format, which might not match the specific visual layout you intended to use.

How do I stop Excel from automatically converting text into dates?

To prevent Excel from converting numbers or text into a date format, type an apostrophe (') before entering your data, or format the target cells as 'Text' before you begin typing.

Does changing the date format alter my actual data?

No. Changing the cell format using the Format Cells dialog only changes how the data is visually presented on the screen. The underlying date value stored in the spreadsheet remains exactly the same, as you can verify in the formula bar.

Document & File Issues