I have never had this problem before, and now, all of a sudden ..!! I'm
frustrated! Ok..here's what's going on:
What I'm trying to do, is format a column of cells, or even just an
individual cell, to display a date as mm/dd/yy. I remember doing this
before, and only having to type in, for example, 010106 if I want the cell to
display 01/01/06 (which obviously woudl be for January 1, 2006). What's
happening is, after i type in my numbers, and hit enter to move on to the
next cell- it changes it for some reason. If i type in 010106 into a date
formatted cell, it displays "09/01/27". What's going on, and how can I fix
it?