Monday 23 May 2011

Excel do not sum decimal points


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


Settings should be:

Tools - Options -

International

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


and restart excel to take effect!

No comments:

Post a Comment