On Thu, 12 Jan 2006 18:01:17 -0600, jermsalerms
wrote:


Didn't catch that scenario!


The problem is that I am uploading the spreadsheet as a .csv to a
program that fills in the Date of Birth field and it will only
recognize 8 digit format.

Also it is not something that can be done by hand because I get a list
of 4000+ once a month.

Any suggestions for accuracy on a majority of them

I think you will need to change the data entry method to produce consistency.
--ron