I am setting up an Excel spreadsheet to include the date of birth of past relatives. When I put a date of say 22/09/1938 it will convert to 22 September 1938. A problem arises when I insert a date from the 1800's. I tried to insert a date of 25/08/1886 and it stays as that instead of converting to 25 August 1886. Can anyone suggest a remedy?
Thank you VoG™ but that link is too far advanced for me to follow. Pleas accept my thanks for taking the trouble to post but I need step by step instructions. I don't know how to get Excel to accept pre 1900 years in the same way it will accept post 1900 years. Most of my past relatives lived in the 1800's so I need to see if I can reconcile this problem. I think the best way forward is for me to accept that all date prior to 1900 will have to be in the 25/08/1886 format. Your time and effort is much appreciated.
Thank you all for your input. As I said above I will just leave the dates in the 25/08/1888 format. I have made note of all the suggestions and will peruse them at my leisure. Again thanks to one and all for your input.