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?


--
ftpsteve
------------------------------------------------------------------------
ftpsteve's Profile: http://www.excelforum.com/member.php...o&userid=16630
View this thread: http://www.excelforum.com/showthread...hreadid=314972

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


"ftpsteve" wrote in message
...

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?


--
ftpsteve
------------------------------------------------------------------------
ftpsteve's Profile:
http://www.excelforum.com/member.php...o&userid=16630
View this thread: http://www.excelforum.com/showthread...hreadid=314972

Hi
what is your exact formula?
Also check the format of these cells

"ftpsteve" wrote:


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?


--
ftpsteve
------------------------------------------------------------------------
ftpsteve's Profile: http://www.excelforum.com/member.php...o&userid=16630
View this thread: http://www.excelforum.com/showthread...hreadid=314972