How do I convert the date from 1900's to 1800's?
I'm working on a spreadsheet in which I'm using dates from the 1800's. Is
there a way to convert the date from 11/29/65 to 29 November 1865? I've
tried to change it, but of course it goes to 1965 instead. In the meantime
I've been changing each date manually, but I wanted to see if there was an
easier and quicker way to convert the dates. Thanks!
|