Hi my find and replace does not work right this morning. I use to just be able to type 12/06/09 and it would find it, now for some reason it will not unless I type 12/06/1909 or 12/06/1809. In all my D-bases my dates are formatted 03/14/01. I have also gone into the regional setting and changed the Short Date Format to MM/dd/yy it was MM/dd/yyyy.
Can someone please help me I only look for a person by the DOB in all 156 D-bases.
I have Excel 2003 and windows XP