blank fields become "0"

D

Daves

hi,
if I "duplicate" value from one sheet to other by "=Sheet1!A6", blank fields
on Sheet1 show up as "0" on Sheet2? How can I fix this?

regards,
D
 
K

Ken Johnson

Daves said:
hi,
if I "duplicate" value from one sheet to other by "=Sheet1!A6", blank fields
on Sheet1 show up as "0" on Sheet2? How can I fix this?

regards,
D
Click to expand...

Hi D,

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

Ken Johnson
 
B

Bax

Hi Dave,

You can try to enter "=IF(Sheet1!A6="","",Sheet1!A6)" in the field.
This will prevent the "0" from showing.

Regards,
Peter
 
Top