The reason you have not found a satisfactory answer is that there is no good
answer for this kind of data... For example how should we handle 11106... Jan
11 or Nov 1. There is no way to interpret that without knowing the intent of
the person who entered the data in the first place.

--
HTH...

Jim Thomlinson


"Cat" wrote:

Yes, I know this has been covered a MILLION times yet although I've looked
through many threads, I can't seem to find one that covers this EXACTLY.
I'm importing info into Excel 2000. One of the columns is a date field..
but it is not consistent.. for example, it can read 10206 or 100206 (both to
mean Oct 2, 2006). When I try to format it into a date (10/2/06) it turns it
into something strange, such as 01/02/36. Don't know why this is happening.
When I click on a seperate cell w/out any info (that is formatted to a date
field), and type in 100206 it STILL doesn't come out right! HELP!!! I need
this info for tomorrow!!!