Hi Marsha, I realised what the problem was as soon as I saw it. Peter caught me with this one a while back. My regional settings in the Contol Panel were set differently to whatever the people who created the file had set theirs at. To my way of thinking this shouldn't affect anything sent to me or downloaded from the net. You should make your files so that everyone sees the same information regardless of settings on their computer. We usually mix dates and single years in the one column. Databases don't like this and will scramble them all up. A database expects to find the one type of data in each column whether it be either dates or years but not both. The easiest way around the problem is to format the column as TEXT before entering any data. If you have trouble setting up a database in Excel contact me and we'll work through it. Yours, Garry.