ExcelBanter - Excel

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel - Sum Error (https://www.excelbanter.com/new-users-excel/203792-excel-sum-error.html)

growtree

Excel - Sum Error

I'm having a problem with adding a column of numbers. I locate the cell in
the column that I want the total, hit AutoSum and the Enter and the answer in
the cell is all #########. What am I doing wrong?

Peo Sjoblom[_2_]

Excel - Sum Error

Widen the column, the result of the sum is to wide to be viewed

--

Regards,

Peo Sjoblom

"growtree" wrote in message
...
I'm having a problem with adding a column of numbers. I locate the cell
in
the column that I want the total, hit AutoSum and the Enter and the answer
in
the cell is all #########. What am I doing wrong?

Sean Timmons

Excel - Sum Error

Also, while in the cell, go to Format - Cells and ensure it is formated as
Number.

"Peo Sjoblom" wrote:

Widen the column, the result of the sum is to wide to be viewed

--

Regards,

Peo Sjoblom

"growtree" wrote in message
...
I'm having a problem with adding a column of numbers. I locate the cell
in
the column that I want the total, hit AutoSum and the Enter and the answer
in
the cell is all #########. What am I doing wrong?

All times are GMT +1. The time now is 03:32 AM.