Rick
H24 is empty. I have gone thorough & formatted all cells involved in the
formulae as numbers. None of these cells have text typed into them.
How can I check to see if a text blank space is entered - without
looking at 5 columns x 1500 rows.?
Thanks

Rick Rothstein (MVP - VB) wrote:
You don't show us what is in H24. Anyway, if any of those cells have
text in them (including a blank space, which wouldn't be visible), then
that would generate the error you are getting; so that is the first
thing you should check

Rick


"Doug Boufford" wrote in message
...
http://tinyurl.com/47h8lb

Using Excel 2003 in WIN XP
Link above has a pic of part of the spreadsheet showing errors

Simple formula adding cells returns a #value! error.
If I just enter 0.00 in each cell referenced in the formula, the error
is solved (as in row 22. How can I set the options so that if a cell
is just missing amounts, the formula will still work correctly?
I could fill in 0.00 in empty cells, but there are roughly 1500 rows
of data............
TIA
Doug