Hi people of the superior power of excel,


I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?




--
seno