J
JonathanK1
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 matte
which format I choose, it comes out as different numbers. It'll show a
01/26/7435 or something crazy...I tried custom etc. What I want is fo
it to show up as 01/01/1999 - for the entire columb. Shouldn't b
hard...yet I've tried almost everything. I even opened a ne
spreadsheet and started from scratch.
Or the numbers will switch from 01011999 (which I want to read a
01/01/1999) to ##########
When I type in 01011999 in a cell, then switch it to dates (no matte
which format I choose, it comes out as different numbers. It'll show a
01/26/7435 or something crazy...I tried custom etc. What I want is fo
it to show up as 01/01/1999 - for the entire columb. Shouldn't b
hard...yet I've tried almost everything. I even opened a ne
spreadsheet and started from scratch.
Or the numbers will switch from 01011999 (which I want to read a
01/01/1999) to ##########