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...
I edited my post and added a copy of the Spreadsheet. Thanks.
The problem is: the Show Formula option is set.
You can deselect the option by clicking Show Formula or by pressing ctrl+` (back-quote).
- Thanks alot!
- Any idea why it keeps changing the date from what I put in?
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
