JonathanK1 wrote on 11/01/2013 :
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 ##########.

<FWIW
Adding to the date issue.., My XP machines accept date input as m/d and
result as "m/d/2013". My Win7 machines require input as d/m in the same
scenario, to result as "d/m/2013". This is controlled by the system
date format AFAIK! Using the keyboard shortcut "Ctrl+;" to auto-enter
the current date works the same in either OS but the result is still
system date format.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion