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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
