Why does the date change when I tab to a new column?

[Kris]

I've formatted the column in the date format I want, but when I type in the
date and then tab to the next column, the date changes on me. I remember this
happening to me before, but I don't remember how I fixed it.