Dates

[lawson]

i have a column of dates that were entered by another program. the values
that end in "06", for example, Excel is not recognizing them as dates, and
subsequently when i try to change the format to "dd/mm/yyyy", it does not
correct these cells. i have both formaically and manually changes the years
to a 4 digit year (31/01/06 --> 31/01/2006), but Excel still does not
recognize it as a date. (if i enter a 1*c1 and copy the formula down beside
the date column, some values result in VALUE! and some result in the 39367
range). how can i get all dates to be recognized?

Ex:
31/01/06 not recognized as a date, even if i manually change to /2006
05/10/2007 recognized as a date
04/01/2007 recognized as a date
04/01/2007 recognized as a date
11/06/2006 recognized as a date
18/07/05 not recognized as a date, even if i manually change to /2005
03/01/2006 recognized as a date
30/08/06 not recognized as a date, even if i manually change to /2006
13/10/06 not recognized as a date, even if i manually change to /2006

Thank you very much.

 

[Jerry Whittle]

First off is this an Excel question or an Access database question? Are you
having trouble with data in Access not being seen properly in Excel or
trouble importing Excel data into Access?

This forum is for Microsoft Access. If a pure Excel question, you question
would be best answered in an Excel forum.

 

[lawson]

sorry, i realized that i clicked the wrong forum right after i posted...'been
a while' is my excuse . cheers

 

[Jerry Whittle]

I understand all too well. It's like that mega-second that happens as the car
door is closing and you see the keys still in the ignition.

If you are in the UK, keep dry.