Zeros in Linking

  • Thread starter Thread starter BrianK
  • Start date Start date
B

BrianK

In my current worksheet I have created links to a second
worksheet in the same file. I notice that Excel throws
the value of zero in my current worksheet even through
there is no zero in the other worksheet. In other words,
whether there is a null or 0, I am seeing a 0 in my
current worksheet. Is there a way to eliminate this?
 
BrianK said:
In my current worksheet I have created links to a second
worksheet in the same file. I notice that Excel throws
the value of zero in my current worksheet even through
there is no zero in the other worksheet. In other words,
whether there is a null or 0, I am seeing a 0 in my
current worksheet. Is there a way to eliminate this?
Click to expand...

Tools > Options > View tab
Uncheck "Zero Values".
 
Ideally I want Excel to show a null value when linked to
an empty cell. However, it shows a zero. This is not
what I want so unchecking zero values may not solve my
problem. Is there a way for Excel to link to an empty
cell and show a null value?
 
Only by formatting like in General;General;
or uncheck zero values under tools>options>view, of course then real zeros
won't be shown,
otherwise you can wrap the link in an IF function

=IF(Sheet1!A1="","",Sheet1A1)
 
Back
Top