empty copied/linked cells contain 0
I am attempting to link a few Excel files to a worksheet in a separate file
that contains my master data. The link works, but, empty cells in the range
selected now contain a zero, in the target files. How do I prevent cells
from being zero filled? I have set columns to TEXT. Excel 2000.
Thanks
|