This is driving me batty. I hope someone can help. This is excel 2010.

When I type in 01011999 in a cell, then switch it to dates (no matter which format I choose, it comes out as different numbers. It'll show as 01/26/7435 or something crazy...I tried custom etc. What I want is for it to show up as 01/01/1999 - for the entire columb. Shouldn't be hard...yet I've tried almost everything. I even opened a new spreadsheet and started from scratch.

Or the numbers will switch from 01011999 (which I want to read as 01/01/1999) to ##########.