June 18, 2009

Excel do not sum decimal points

Problem: When there are numbers with decimal point, sum function is not working

Settings should be:

Tools - Options -


set as:
Decimal separator .
Thousand separator ,
unckeck Use system separators

and restart excel to take effect!


Anonymous said...

I solved this a moment ago by changing my commas into fullstops and vice-versa.

Anonymous said...

How did u solve this problem.. i m facing still this problem after applying the instructions