Hi Mark:
I understand the part regarding Date entry versus true Date value in Excel. Also, no problem regarding the coercion of the the converted text string into a numeric value.
What I am curious about is why would Excel accept the '-' character and not the '/' -- and as you pointed out, it is the same in Custom formatting numbers as well.
I surmise that '/' has some special features, even though both characters also happen to be arithmetic operators as well. I also recognize that because both happen to be arithmetic operators has nothing to do with this issue.
Regards!
Like this thread? Share it with others