Thread: Linking sheets how do I display the zeros (0) as blank cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Linking sheets how do I display the zeros (0) as blank cells
Try something like this:

=IF(Sheet2!A1="","",Sheet2!A1)

--
Biff
Microsoft Excel MVP


"kat106" wrote in message
...
I have a blank cell on the first worksheet that I am linking to a second
worksheet - when I link the two worksheets the blank cell now displays a
zero
(0) on the linked sheet (second worksheet). I want this linked cell to be
displayed as blank with no zero (0) in the cell, how can I do this?


Reply With QuoteReply With Quote