ExcelBanter - "###" instead of a sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "###" instead of a sum (https://www.excelbanter.com/excel-worksheet-functions/215721-instead-sum.html)

Bea

"###" instead of a sum

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

Dave Peterson

"###" instead of a sum

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 wrote:

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

--

Dave Peterson

Bea

"###" instead of a sum

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

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 01:00 PM.