Issue with sum in excel

Question

Hi All,&nbsp;&nbsp;When im using the excel function to calculate the numbers, the formula gives me zero

riny_van_eekelen · Answer

LaurenceV&nbsp;And which function would that be?

laurencev · Answer

i just checked and looks like my excel only display in the status bar count instead of average, sum etc.. basically when i have a . it recognizes the column as text

riny_van_eekelen · Answer

LaurenceV&nbsp;You mean something like this, in the bottom right hand corner of the screen?If you only see "Count: ... ", the cells selected, indeed, contain only texts.&nbsp;You wrote "when I have a . it recognizes....". Does this mean you are typing numbers with a decimal point? Perhaps your local settings require a comma as the decimal indicator.

laurencev · Answer

where is the local setting to change this please

laurencev · Answer

Basically i dowloaded a report from Google adwords and the numbers contain decimal point instead of comma so i would like to change this for all the column automatically. i tried already change this with text to column and it didnt work

Forum Discussion

Issue with sum in excel

6 Replies