EXCEL DOES NOT RECOGNIZE NUMBER WITH COMMAS FOR FORMULAS

Occasional Visitor

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!

1 Reply

@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.

S1809.png