View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Ghost numbers in blank cells

Some people have a bad habit of 'clearing' a cell's value by pressing the
Spacebar followed by Enter. Put a space back in the cell that you deleted
and see if that exhumes your error. If so, find out who is doing the
dastardly deed and spank them.

"scott" wrote:

Just a questilon. In my ss I had a value erro show up, the formula was
correct and when I tracked down the cell that the formla was using it was
blank. I clicked on the cell (blank , no formula or anything else) and hit
delete, this cleared the vaule error. Does anyone know what this is, this is
the second time it has happened, Haunting?

thanks scott