Found it! Somehow I included I7 while summing a range of data in column E!
Once I deleted I7 from the summation, it accepted the text.

Thanks for responding.

--
al


"Tyro" wrote:

It appears that I7 which is blank is being used in formulas in columns E and
L and the blank is probably being treated as a 0 (zero) which is acceptable
to the formulas. But when you enter text ins I7, the text is not acceptable
to the formulas and they return a #Value! error.


"al" wrote in message
...
I have a series of data in columns and rows. The row titles are in a colum
that runs from I3 through I15. I have row titles in all rows except I7.
When I put a row title in I7, the data in column L and in the data source
column E are replaced with the VALUE notation. When I delete the text in
I7,
the numbers return.

Any thoughts?

Thank you

Al Charbonneau
-
al