Have you tried formating the cells as numbers?

"Jewels" wrote:

I'm confused! I've been entering =sum formulas without a problem. Suddenly,
today, all I get is a "0" total instead of the sum of the column. For
instance, =sum(d36:d43) should equal 17, but it shows a 0. The cells are
formatted as "general". What happened?