Zeros only but not other numbers

[kuzna26]

Hi guys please,
please I have posted the zero questions , in fact what I need is that

A1 -A10

B1 - B10

C1- C10

if I insert 0 in A1 then B1 and C1 show automatically Zero ... It is only valid for Zero , for other numbers ( i.e. 1, 2, 3 ...) that
I insert in A1 should not be shown autonatically in B1 and C1

Thank you ,

[martindwilson]

Put this in b1
=IF(AND($A1=0,$A1<>""),$A1,"") fill across to c1 then down

[FDibbins]

How is this any different from your other post here?

http://www.excelforum.com/excel-form...387-zeros.html

If you did not recieve the answer you wanted, please continue on that thread, there is no need to open a new thread