I have about 4000 dates in a spreadsheet, some of the dates are in the
'mm/dd/yyyy' format and have no problem with them; however, interspersed
throughout the file are 'yyyy' dates only that tend to default to an
erroneous 'mm/dd/yyy' format. i.e., 1825 may get translated as 01/20/1905.
How can I have the 'mm/dd/yyyy' and 'yyyy' dates in the same column?
I've tried text and custom but still have no relief --

SgtBob