Oct 26 2021 04:06 AM
Hi All,
When im using the excel function to calculate the numbers, the formula gives me zero
Oct 26 2021 05:48 AM
Oct 26 2021 05:55 AM
@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.
Oct 26 2021 05:59 AM
Oct 26 2021 06:56 AM
@LaurenceV Use Find and Replace. Ctrl-H. Find . (=dot), Replace with , (=comma)