In a column, I have dates of the format 20130527. 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.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
It's the number of days passed from Friday, December 29, 1899 and your date. References & proofs:


