Linking workbooks

B

BB

When I copy and paste special from one workbook into
another, blank cells show a 0 (zero). How do I avoid this?
 
R

Ron de Bruin

Hi BB

Yes : your formulas with no value will show 0

You can uncheck Show zero's in Tools>Options ...View
 
G

Gord Dibben

BB

If these are formulas linking back to the target sheet, you could trap the
blanks with an IF statement.

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

OR Tools>Options>View. Uncheck "Zero Values"

Gord Dibben Excel MVP
 
B

BB

Thanks Gord, that worked!
-----Original Message-----
BB

If these are formulas linking back to the target sheet, you could trap the
blanks with an IF statement.

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

OR Tools>Options>View. Uncheck "Zero Values"

Gord Dibben Excel MVP

this?

.
Click to expand...
 
Top