I can entered data in Excel and use the autosum feature and that works or I
can use the formula =sum(a1..a55) and that works. However, if I copy and
paste numbers from another spreadsheet and tried those function either I get
zero and the formula is correct. I can even put =sum() mark the columns
instead of typing in the range and it will still give me zero. It seems to
be a copy and paste problem? I have never came across this before. I also,
have a program that will list a report and I push a button that sends it to
Excel and same thing.