Forum Discussion

Jo-AnnDP's avatar
Jo-AnnDP
Copper Contributor
Oct 03, 2022

FORMULA / CALCULATION ISSUES

For some reason I'm unable to do any formulas

This is my formula

once I press enter:

and also no average / sum etc showing at the bottom:

 

 

excel
Formulas and Functions
  • ecovonrein's avatar
    ecovonrein
    Iron Contributor
    Oct 03, 2022
    all the (supposed) numbers are left-aligned, suggesting that they are text values. You may be using an English Excel to process European numbers?
    • Jo-AnnDP's avatar
      Jo-AnnDP
      Copper Contributor
      Oct 03, 2022
      ecovonrein - it is set to general - i've never had this issue. updated my pc over the weekend and now i'm experiencing one problem after the next
      could there be another way to fix this problem?
      • ecovonrein's avatar
        ecovonrein
        Iron Contributor
        Oct 03, 2022
        Again, I am guessing that you may normally be working with European numeric format and your Excel has switched to English number format. Either your Excel installation has changed UI language or, if you always worked in an English installation in Europe, you have lost your preferred number format. Just go into File/Options and change the decimal and 1000s seperators. (You want "." for 1k, "," for decimal by the looks of it. I cannot know your environment for sure. I am just guessing from your picture.)

Resources