Forum Discussion
robert4917
Mar 07, 2023Copper Contributor
all my dates suddenly appear as the underlying number
I have built and used this spreadsheet for years. Suddenly one day all the dates now appear as the underlying number instead of the normal date format....like MM/DD/YYYY Even when format such a ...
HansVogelaar
Mar 07, 2023MVP
Activate the Formulas tab of the ribbon.
Make sure that the 'Show Formulas' button in the 'Formula Auditing' group is not highlighted.