Thread: hide results when cell value is 0 due to linking worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default hide results when cell value is 0 due to linking worksheets
In place of the usual:
=A1
use:
=IF(A1="","",A1)
--
Gary's Student


"Barry FL" wrote:

When I link a worksheet to another worksheet to use the values, if there is
no value in the primary worksheet than a 0 is shown in that cell on the new
worksheet. is there a way to hide the 0 until a value is entered in the
primary worksheet.
Reply With QuoteReply With Quote