I have formatted the column etc and done all that Excel help explains. but
the date keeps converting to a year number, not mm/dd/yyyy which is what I
want. This happens only in column A.