DateFormat
Latest
What to do when the wrong date is pasted in Excel
From Quentin Tarantino's classic, Pulp Fiction: Vincent: ...But you know what the funniest thing about Europe is? Jules: What? Vincent: It's the little differences. I mean, they got the same [things] over there that we got here, but it's just - it's just there it's a little different. Jules: Example? Vincent: ...Do you know what they call a Quarter Pounder with Cheese in Paris? Jules: They don't call it a Quarter Pounder with Cheese? Vincent: Naw, man, they got the metric system, they wouldn't know what the [heck] a Quarter Pounder is. Jules: What do they call it? Vincent: They call it a "Royale with Cheese". Jules: "Royale with Cheese." Vincent: That's right. Although they both use a different versioning nomenclature, the PC and Mac versions of Microsoft Excel are essentially the same app -- except, as in the words of Vincent Vega, they're just "a little bit different." And one of these differences is their respective date systems. By default, Excel for the PC uses the 1900 date system, while its Mac counterpart uses the 1904 date system. In most cases, users won't notice this subtle difference. For example, a file saved by a PC version of Excel using the 1900 date system will be recognized as such when it's read by its Mac counterpart, and vice versa.
