Linking Databases

S

Stipe

I am having a problem with Excel in XP. I am pulling
numbers & characters into a template and if there is no
character excel is automatically making it a zero. How
do I fix this.

Thanks.
 
D

Debra Dalgleish

Instead of a simple cell reference, e.g.: =Sheet2!B1
wrap the reference with an IF formula:

=IF(Sheet2!B1="","",Sheet2!B1)
 
Top