It doesn’t help that Excel tries to be “smart”

Oh, putting in a lot#? Let’s make that a date.

Most people don’t set up an excel for what they want, they start using excel with what they have