Forum Discussion
Sum function
Sum of my columns is coming up 0 or 0.00 although I've used the same function for years. Why is this happening??
How can I convert those numbers from text to numbers, if that's the problem.
How can I convert those numbers from text to numbers, if that's the problem.
Assuming, for illustration sake, that the errant cells are in column A, in an adjacent column enter something along the lines of =VALUE(A1) and copy that down to all needed rows. That will convert text values to true numbers.
(I frequently download data from a bank, credit card transactions and the like, and use a formula like that to convert to all true numeric values.)
