Note that just "changing the format" will not change the underlying
value from text to a number. Copy an empty cell, select A1:A12 and
Edit|Paste Special|Add

Jerry

Bob Phillips wrote:

That sounds like the cells A1:A12 are formatted as text to me. Reformat
those as well.