In a column, I have dates of the format 2013-05-27. When I selected "Default Formatting", the dates got changed to five digits, for example, 41422. Where does this number come from? It's not even subtracting the numbers.
It's the number of days passed from Friday, December 29, 1899 and your date.
References & proofs:
|show 3 more comments|