Hacker News new | ask | show | jobs
by johnnyo 848 days ago
Insightful solutions aren’t always correct solutions.

Take a look at how Excel helpfully makes things dates or numbers, even when you don’t want them to be treated as such.

There’s no “insightful” way to understand that a column of numbers really wants to be treated like text or that 20-DEC-82 is a product code vs a date.