software

I've linked 1 excel file to another. Some fields in origin file are empty,
in linked file they show as a '0'. How do I lose the '0'?

You could use something like
=if(isblank( inked info ),ValueIfTrue,ValueIfFalse)quot;Anitaquot; wrote:

gt; I've linked 1 excel file to another. Some fields in origin file are empty,
gt; in linked file they show as a '0'. How do I lose the '0'?

quot;Anitaquot; wrote
gt; I've linked 1 excel file to another. Some fields in origin file are
empty,
gt; in linked file they show as a '0'. How do I lose the '0'?

Another way is to frame the link formulas along these lines:

=IF(Sheet1!A1=quot;quot;,quot;quot;,Sheet1!A1)

=IF([Book1]Sheet1!A1=quot;quot;,quot;quot;,[Book1]Sheet1!A1)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---