"###" instead of a sum

[Bea]

Instead of a sum total (auto sum), I sometimes get "######." Can anyone help
me? I have Excel 20007.

 

[Dave Peterson]

Widen the column or make the font smaller.

Changing the cell's format to General may work, too. But you may not see the
format you like.

 

[Bea]

Thanks Dave. I'll try these when the problem comes up next time.