Auto Sum Errors

%3CLINGO-SUB%20id%3D%22lingo-sub-2694346%22%20slang%3D%22en-US%22%3EAuto%20Sum%20Errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2694346%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20numbers%20all%20formatted%20as%20follows%3A%26nbsp%3B%20%26nbsp%3B100.0000%26nbsp%3B%3C%2FP%3E%3CP%3EI%20try%20to%20AutoSum%20the%20list%20of%20numbers%3B%20it%20has%20always%20added%20up%20the%20numbers%20%26amp%3B%20put%20the%20sum%20in%20the%20field%20following%20those%20I%20selected%20for%20summing.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20instead%20of%20adding%20them%20up%20it%20inserts%20a%20sum%20formula%20in%20the%20top%20field.%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%3F%20What%20have%20I%20done%20wrong%20%26amp%3B%20how%20do%20I%20get%20AutoSum%20working%20again.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2694346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2698338%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Sum%20Errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698338%22%20slang%3D%22en-US%22%3ECan%20you%20provide%20a%20screenshot%20of%20it%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a list of numbers all formatted as follows:   100.0000 

I try to AutoSum the list of numbers; it has always added up the numbers & put the sum in the field following those I selected for summing. 

However, instead of adding them up it inserts a sum formula in the top field. 

Why? What have I done wrong & how do I get AutoSum working again. 

Thanks,

2 Replies
Can you provide a screenshot of it?
here is the screen shot - The problem is specific to this worksheet as AutoSum works in others.
I have tried every I know to insert the full sheet & to then copy & paste, nothing worked. Sorry

PTO Balance
=SUM(A2:A29 This field to the left had a PTO Balance also but the formula was written over the
numbers in the field when I clicked AutoSum after highlighting the entire
column of numbers expecting the total to be added to the 1st empty field at
the bottom of the list. Nothing appeared there.
I'm sorry I could not send you the entire worksheet.