Try this: enter 1 in an empty cell and copy it; seelct all the cells in
problem column and use Edit| Paste Special -Multiply.

"cdehrlich" wrote in message
...
Not all numbers in a column are being added to the sum. If I format all as
$,
not all of the numbers get the format.