Forum Discussion
Formula Errors
I was creating a spreadsheet and used the SUM function to total up the columns individually as well as link it to a main cell to show the total of all columns. However, it gave me calculation errors...
Thanks but that doesn't help. When I put 092321 it comes back as 10/05/52
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