Forum Discussion
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 ...
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.