"Value" Error
 

I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?

"Value" Error
 

Sorry, my crystal ball is cloudy. Perhaps we might stand a better chance of
helping you if you were to tell us what formula is giving the "value" error?
--
David Biddulph

"Abacus28" wrote in message
...
I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells
that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?

"Value" Error
 

My guess is that the blank is in fact a space and that you use operators
l;ike +, -, / etc, a space is text and calculate with text will give you
value errorsnote that if you use SUM like

=SUM(A1,A3,A9)

it will ignore text values while

=A1+A3+A9

will throw an error

test one of the balnk cells with

=LEN(A30)

replace A30 with that particular cell, if it doesn't return 0 it has text
values albeit not visible

--


Regards,


Peo Sjoblom




"Abacus28" wrote in message
...
I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells
that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?

"Value" Error
 

Dependent on the error, you might also have an if statement reference to a
sell that is blank, but without a qualifier of what to do if the cell is
blank.

God Bless

Frank Pytel

"Abacus28" wrote:

I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?

"Value" Error
 

Gee, how about some spell checking!


Peo


"Peo Sjoblom" wrote in message
.. .
My guess is that the blank is in fact a space and that you use operators
l;ike +, -, / etc, a space is text and calculate with text will give you
value errorsnote that if you use SUM like

=SUM(A1,A3,A9)

it will ignore text values while

=A1+A3+A9

will throw an error

test one of the balnk cells with

=LEN(A30)

replace A30 with that particular cell, if it doesn't return 0 it has text
values albeit not visible

--


Regards,


Peo Sjoblom




"Abacus28" wrote in message
...
I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary
worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells
that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?