Forum Discussion
Formula Errors
In Excel, dates are represented by an integer, with 1 representing 1/1/1900 normally.
In Show Formula mode, dates are shown by their integer value.
Similarly, times are represented by a fraction of a day, with 1/24 representing one hour.
In Show Formula mode, times are shown by their decimal value.
Likewise, percentages are shown by their decimal value. For example, 12.34% is shown as 0.1234.
Etc, etc, etc.
- Thanks but that doesn't help. When I put 092321 it comes back as 10/05/52
Assuming that you wanted to enter the 23rd of September, 2021, you must indicate to Excel in some way that you want to enter a date:
9/23/21 or 09/23/2021 or 23-Sep-21
It is possible to make Excel convert 092321 to the date 09/23/2021, but that would require VBA code.
ShareholdersRMA wrote: ``When I put 092321 it comes back as 10/05/52``
Because the F31 is formatted as Date, and the title in F27 is Estimated Complete Date.
I was wondering why you are entering 92321, in the first place. And I was wondering why you are entering a 2152 date.
But that's your business. I cannot help you with that.
ShareholdersRMA The cell where you entered 092321 is formatted as a date. Excel drops the leading zero and returns a date based on the value 92321, which happens to be October 5, 2152.
If you want the cell to display exactly what you enter, format it as a text en re-enter 092321
