I have a database with dates ranging from 1839 to the present. I tried to
format date as mm/dd/yyyy and everything works fine. When I needed to change
the format to yyyy/mm/dd, only the dates after 1900 were formatted. Is there
a way to do this without retyping every cell in the correct format. I have
over 28,000 records