Forum Discussion

Dantao's avatar
Dantao
Copper Contributor
Oct 03, 2022

EXCEL DOES NOT RECOGNIZE NUMBER WITH COMMAS FOR FORMULAS

Hey guys!

 

Need  a HUGE help that maybe is simple...

 

To do accounting work when I use the excel and have the numbers like "100,20" or "20,00" and want to do a SUM formula it never works, only if I change the number to "100.20" or "20.00".

 

Since when I download this from another source and numbers come in commas I cant do the formulas and its very frustrating and I dont see a permanent way to solve this issue.

 

Any help ?

 

Greetings from Portugal!

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 03, 2022

    Dantao 

    You have two options:

    • Set the decimal separator in your operating system (Windows or MacOS) to comma, OR:
    • Change the decimal separator for Excel only:
      • Select File > Options.
      • Select Advanced in the navigation pane on the left.
      • Clear the check box 'Use system separators' and change the decimal separator to a comma and the thousands separator to a point.
      • Click OK.

Resources