Excel Shows Formula Results as Default Values Instead of Dates: Disable Formula View
Question details
The user needs Excel to display calculated date values as formatted dates instead of default numeric or formula output.

- 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 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.
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.
Click File in the top-left corner, then select Options.
In the Excel Options dialog, click Advanced in the left menu.
Scroll to the 'Display options for this worksheet' section and select the relevant worksheet from the dropdown.
Clear the checkbox for 'Show formulas in cells instead of their calculated results'.
Click OK, return to the worksheet, and confirm the dates now display with the intended date format.

Toggle Formula View with the Ctrl+` Shortcut
Use this quick toggle when Formula View was switched on accidentally and you only need to restore normal display.
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. 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. Open the Formulas tab: Click the Formulas tab in the ribbon to reveal formula auditing tools.
- 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. Verify the date format: Select the affected cells, go to Home > Number Format, and confirm the date format is now applied.

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.




