Formatting the cells as a number isn't enough to change the value in each of the
You have a formula like =sum(a1:a10) right?
Try this formula in an empty cell: =count(a1:a10)
This will return the number of cells that are actually numbers. Then try the
technique that Gord suggested. Watch what happens to your =sum() formula and
the =count() formula.