Forum Discussion
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 the serial number. Any suggestions to go back to normal viewing of the dates?
2 Replies
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.
Riny_van_Eekelen Thankyou!! That was the problem and solution!
