Sum = $0.00

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When calculating a sum of several cells my answer is coming up $0.00...I have
them all formatted but something must be wrong??? Can anyone shed some light..
 
Excel may think your data is text, but there is an easy fix:

1 in an un-used cell, enter 1
2 copy the cell
3 select the cells are are trying to add
4 then edit/paste/special with the multiply button checked

This will convert the values into true numbers.
 
Back
Top