Forum Discussion
DATE FORMATTING from the 1600s
Hello! I'm helping a friend who handles genealogy records for the entire island of Malta. We have date conversion issues. I learned how to reformat and strip cells of TEXT formatting. The problem...
Date is sequential integer number where 1 is Jan 01, 1900 (for Windows). Applying format you only show such number in user-friendly way. For the early dates there are some workarounds, but in any case these will be not dates in terms of Excel.
Perhaps you may share small sample file to illustrate the question.