Forum Discussion
tiurischoen
Oct 02, 2024Copper Contributor
Excel changes dates to numbers
In excel suddenly al the dates are formatted to serial numbers. the settings are al checked and are noted as "date". When selecting the cell is shows the correct date, but in overview you only see th...
Riny_van_Eekelen
Oct 02, 2024Platinum Contributor
tiurischoen What kind of "overview" are you referring to?
Perhaps you accidentally enabled "Show Formulas" on the Formulas ribbon. Press the button again to disable it.
tiurischoen
Oct 02, 2024Copper Contributor
Riny_van_Eekelen Thankyou!! That was the problem and solution!