unfortunately this data is coming from a third party provider and the
will not standardize their data...its always got to be hard.

I was thinking of making a few assumptions with the dates that could
have different combinations...such as 12573....(if 1st two numbers are
10,11, or 12...then assume that that is the month).

At least that way I can get maybe about 85% of them in correctly and
just confirm these birthdates with the client when we speak with them.


Yes these are all 19xx years.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=500884