Forum Discussion
Issue with sum in excel
Hi All, When im using the excel function to calculate the numbers, the formula gives me zero
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
LaurenceV 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.
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.
- where is the local setting to change this please
- 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
LaurenceV Use Find and Replace. Ctrl-H. Find . (=dot), Replace with , (=comma)