Column Not Calculating

F

ftpsteve

I have a financial spreadsheet that has a ton of columns.

In the total colums, I can calculate the row. But when I try to
calculate that column, I get 0.00.

If I try to calculate the column somewhere else, I still get zeros. It
is acting like there are no values in the cells in the column.

Any ideas?
 
A

Arvi Laanemets

Hi

Check the cell format in column - it's probably Text. When this is the case,
then after reformatting the column, you have to reenter all values/formulas.


Arvi Laanemets
 
Top