View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Cells Appear Blank but aren't

Hi,

Maybe the cell has a formula that's evaluating as a null string. For example

=if(a1="","",A1)

this will show as empty until you enter a value in a1

Mike

"Jennifer" wrote:

Why do the cells in Excel sometimes appear blank but in the function line it
shows that it has info in it?
--
Jennifer