I have thousands of dates to enter. The first batch is all January 1890, the second batch is all February 1890, etc.
I know that I can set a default century in Tools>Options>General.
But what I want to know is, can I somehow either:
- set the year and month to a default, so that I only have to enter the day?
or
- enter the year, month and day in separate columns, then merge or concatenate them as a date?