Excel spreadsheets are hard to get right
win-vector.com
win-vector.com
EDIT: Actually the HTML is mangled and a huge chunk of text is not visible.
The same would apply with dates. Datetimes are zero-indexed floating point numbers incrementing from 0/1/1900 [1]. Whether it's displayed as a date or number is simply a case of what format you select for the cell.
Formatting is then obviously specified as a flag in the metadata because by its nature, formatting is metadata not a value. If you implied formatting by the value stored, you open up all kinds of corner case issues (is "19/5/14", for example, an equation, date or string?).
I think the .xlsx format is really sensible here, and it's the applications that have woeful compatibility.
[1] Yes, 0th January is a date: https://en.wikipedia.org/wiki/January_0
But I took your advice and submitted the bug https://bugs.freedesktop.org/show_bug.cgi?id=86456
edit: and a whopping 1 minute in somebody has linked an empty bug report as a duplicate to this one. nice.