There is definitely a way to automate that process. Even if you can’t somehow sanitize the input before Excel reads it as dates, unfucking the data can definitely be reduced to a single button-push. I’ve based my entire career on my ability to do that.
Reminds me of an adult video I saw a while ago that completely changed how I view pornography.
It was a perfectly normal video of a perfectly normal woman doing a perfectly normal thing. The title of the video was descriptive of the action, and then in parentheses it said, “(NO FARTS)”.
And I’m like… I wasn’t even aware I had a preference either way, but now I definitely do.
What do you mean “spit out”? Is it being put into a new open workbook, an existing open workbook, or is it being saved as a file?
And I don’t mean to suggest I know better than the person actually dealing with the situation (I hate when people do that), but if you can do it manually, it can be automated.