By now, I'm sure you're aware that you have a complicated data problem.
If 10206 is supposed to be 10/02/2006
Then what value would be used to mean 01/02/2006? Wouldn't it also be 10206?
Also....is 11206 11/02/2006? or is it 01/12/2006?

Apart from that...if you can get the values to all be in this form: mmddyy
then you could use <data<text-to-columns and designate the data as Dates
in mdy format.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"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!!!