Hi Cousin_Geo

See John's page about this
http://j-walk.com/ss/excel/usertips/tip028.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Cousin_Geo" wrote in message ...
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