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 tre

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.