Hi I am trying do sum of a column which has looks like the following.
I get the answer as zero. My formuala works for other columns which are just numbers.
How can i solve the above mentioned problem..
Also how do i convert a cell or a range of cells to number?