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


I have also seen this before, but I don't know if my situation is the
same as yours. My experience has only been with files originally
created in an older software program (such as Lotus 1-2-3 or even
earlier versions of Excel).

You can either fix this by finding and clearing said ghost cells, or
you can also change the way Excel deals with them by toggling the
following settings:

Tools - Options - Transition - Transition Formula Evaluation
Tools - Options - Transition - Transition Formula Entry

Hope this info helps.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=498384