Values not showing in either cell or formula bar

[James Irwin]

Hi -

i have a worksheet (tried both excel 2003 and 2007) with cells that appear
blank (i.e. nothing showing in either formula bar or cell itself, even if i
click to edit in cell). However, the =isblank formula returns false so excel
is seeing something i'm not!

I've tried to narrow down what this is and using an if statement (e.g.
=if(relevant cell>9E+307,"yes","no"), it looks like excel is seeing an
enormous number in these cells, somewhere between 9E+307 and 1E+308 (i'm not
a mathmetician so not really sure how i narrow down which value it is
exactly!). Has anyone come across this before?

Ideal solution would be for someone to show me a way to make Excel show that
these cells are not blank without having to reference each relevant cell with
an if or isblank formula which is tricky as there are lots of these "blank
non-blank" cells scattered across various different files. Hope that makes
sense and thanks in advance.

 

[Atishoo]

Im sure you have probably done it already butmake sure there is not a space
in these cells!
You dont have a formula running setting cell values to " " rather than ""?
or anything of that nature?

 

[James Irwin]

nope - no formulae and no spaces!

Im sure you have probably done it already butmake sure there is not a space
in these cells!
You dont have a formula running setting cell values to " " rather than ""?
or anything of that nature?