On 5/6/2018 7:46 AM, dpb wrote:
....

I just tried to enter as a string '5/5/2000' into two cells and format
it as mm/dd/yyyy in one and dd/mm/yyyy in the other and couldn't
succeed; the OS setting as you say interferes and corrupts the one; MS
thinks they know better than the user it appears.
....


"...tried to enter as a string '5/5/2000' into two cells"

That was a typo, actually used '5/6/2000' so can see which is which from
=MONTH() or =DAY() of course.

--