Formatting Issues

Excel Shows Formula Results as Default Values Instead of Dates: Disable Formula View

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 868 views

Question details

The user needs Excel to display calculated date values as formatted dates instead of default numeric or formula output.

Excel Displays Formula Results as Default Values Instead of Dates
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has a worksheet with date formulas, but cells show default values rather than dates; changing cell formats does not correct the display.
Observed behavior
Excel keeps displaying formula results as default values until Formula View is disabled.
Before you start

Before changing number formats, check whether the worksheet is currently showing formulas instead of their results. Open the workbook and confirm whether Formula View is active.

Solution 1Recommended

Turn Off Formula View in Excel Options

Use this method when Excel displays date serial numbers or formula text instead of dates and formatting changes do not help.

When Formula View is enabled, Excel shows the underlying formula or its numeric result instead of the formatted date. Changing the cell format alone will not update the display until this view is disabled.

1
Open Excel Options

Click File in the top-left corner, then select Options.

2
Open Advanced display settings

In the Excel Options dialog, click Advanced in the left menu.

3
Locate the worksheet display options

Scroll to the 'Display options for this worksheet' section and select the relevant worksheet from the dropdown.

4
Clear Show formulas

Clear the checkbox for 'Show formulas in cells instead of their calculated results'.

5
Apply and verify

Click OK, return to the worksheet, and confirm the dates now display with the intended date format.

Turn Off Formula View in Excel Options
Dates display normally: After clearing this option, Excel restores the normal result display and applies the existing date number format.
Direct WPS Office solution

Fix Date Display in WPS Spreadsheets

Open the workbook in WPS Spreadsheets and turn off the Show Formulas view so date formulas display as formatted dates, without changing your file.

  1. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, open WPS Spreadsheets, and load the .xlsx workbook that shows default values instead of dates.
  2. 2. Open the Formulas tab: Click the Formulas tab in the ribbon to reveal formula auditing tools.
  3. 3. Turn off Show Formulas: In the Formula Auditing group, click Show Formulas to toggle it off, or press Ctrl+` to disable Formula View.
  4. 4. Verify the date format: Select the affected cells, go to Home > Number Format, and confirm the date format is now applied.
One-click Show Formulas toggle in the Formulas tabOpens and saves .xlsx workbooks with full date formatting compatibilityFree, lightweight Office suite that handles Excel files smoothlyFamiliar ribbon interface, so Excel users can find settings quickly
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel cell show 45000 instead of a date?

Excel stores dates as serial numbers. When Formula View is enabled, the cell may show the underlying formula or numeric result instead of the formatted date. Turn off Formula View via File > Options > Advanced, then clear 'Show formulas in cells instead of their calculated results'.

Will changing the cell format to Date fix the display?

Not while Formula View is enabled. Disable Formula View first, then apply a Date format from Home > Number Format or Format Cells.

What is the shortcut to turn off formula display in Excel?

Press Ctrl+` to toggle Formula View off and restore normal date display.

Can WPS Spreadsheets open an Excel workbook that shows formula results as default values?

Yes. Open the file in WPS Spreadsheets, click Formulas > Show Formulas to turn the view off, and then check the date format.

Does this issue damage my date formulas?

No, your formulas remain unchanged. The display setting only affects how results are shown, not the calculated values.