Which proves your numbers are text, my guess is that you have invisible html
characters. If you make sure you don't have formatted for any alignments
then if it is text it should be left aligned by default, if it is a number
it should be right aligned


--
Regards,

Peo Sjoblom


"TTHuff" wrote in message
...
Did not work...Shows #VALUE#.

All it is is a spreadsheet for my workers hours. the preceding column is a
product of their hours worked times their wage. The column in question is
just adding all of the total wages. Very wierd this is not working. I dont
have any circular references, it just comes up with 0's.

"andy62" wrote:

Any chance that the data in the columns is not in a numerical format?
Does
something like this resolve the problem:

=SUM(VALUE(A1:A100))

Where the formula is entered using Ctrl-Shift-Enter, not just the Enter
key?
(Of course, change the A1:A100 range to your actual range of cells to be
summed.)

"TTHuff" wrote:

I cannot get the columns to add and give me a total below them.
I get sum= 0.

I tried autosum function, and manually typed formula. just does not
make
sense.