Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values not showing in either cell or formula bar
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 cell9E+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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values not showing in either cell or formula bar
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" wrote: 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 cell9E+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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values not showing in either cell or formula bar
nope - no formulae and no spaces!
"Atishoo" wrote: 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" wrote: 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 cell9E+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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing negative values for formula results in red | Excel Discussion (Misc queries) | |||
How to have cell values of 0 showing as blank | Excel Worksheet Functions | |||
showing and copying a formula in a cell | Excel Worksheet Functions | |||
formula in cell not showing result | Excel Worksheet Functions | |||
Formula result not showing in cell | Excel Worksheet Functions |