Forum Discussion
Date format
I am having an issue formatting dates. Usually when I enter a date, it changes automatically to the selected format I want straight away, but today it's not working. I want the date formatted d...
If you really are going for the year 1724, that is the cause. That date doesn't exist in the Excel universe.. So far as Excel is concerned, the Big Bang occurred on 1/1/1900. All dates are serial numbers beginning with that date. See this link.
So depending on what you are creating, you're going to need to find a different solution. Perhaps store the day, month and year as separate columns altogether. If 1724 isn't actually the date you want, then please come back with a more complete and clear description of what you're seeking to do.