Hi,

In A1 i have the value 1, In B1 let's say 2 and C1 value 3 and in D1 I
have a formula = A1+B1+C1.

I want to print the range A1 to D1 and see the value 6 in D1 but in A1
to C1 I want the excel display to be zero.

I have probably read in thi group that some folks use rightclick on
cell and use Format and use some variation of Custom to achieve this
(not very sure).

Please guide me.

Please
Regards,
Hari
India