blank fields become "0"

[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

 

[Ken Johnson]

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

Hi D,

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

Ken Johnson

 

[Ken Johnson]

OOps

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

Ken Johnson

 

[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