Forum Discussion

ShareholdersRMA's avatar
ShareholdersRMA
Copper Contributor
May 22, 2023

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...
Formulas and Functions
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
May 23, 2023

ShareholdersRMA 

 

The problem is:  the Show Formula option is set.

 

 

 

You can deselect the option by clicking Show Formula or by pressing ctrl+` (back-quote).

 

 

ShareholdersRMA's avatar
ShareholdersRMA
Copper Contributor
May 23, 2023
Any idea why it keeps changing the date from what I put in?
  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    May 23, 2023

    ShareholdersRMA 

     

    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.

    • ShareholdersRMA's avatar
      ShareholdersRMA
      Copper Contributor
      May 23, 2023
      Thanks but that doesn't help. When I put 092321 it comes back as 10/05/52
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 23, 2023

        ShareholdersRMA 

        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.

Resources