When I enter 3/1/10 enter a cell formatted number, date, 3/14/01, it changes
it to 1/3/10. But if I enter 3/19/10 in the same cell it leaves it alone.

It is only on one pc, if I open the same file from a different pc the date
works fine.

Any ideas.

Thanks