Forum Discussion
Issue with sum in excel
Hi All, When im using the excel function to calculate the numbers, the formula gives me zero
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)