Dear Max,

Thanks for your assistance and your note regarding I haven't replied whether
your answer is useful to you. I'm terribly sorry for my late reply but I
remember I did reply back that the answer is useful to me. Anyway, please
accept my apology and I feel the life is easier for having some experts like
you, who is willing to share their knowledge with Excel idiot like me.

Thanks once again.

Freshman.

"Max" wrote:

In Sheet2,

instead of putting in A1: =Sheet1!A1
put in A1: =IF(Sheet1!A1="","",Sheet1!A1)

A1 will then appear "blank" until Sheet1's A1 contains a value

To the OP, Freshman: Try feeding back (reply) to responses given to your
posts. Noticed you've made several posts recently, but have yet to see a
single feedback from you within any thread started by you. We're a friendly
bunch of folks here, and this is supposed to be a discussion. If it worked
for you, tell us. If it doesn't, tell us too, and why, so that we could
help you further.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"Mangesh Yadav" wrote in message
...
For me, pating as well as doing =Sheet1!A1 results in "" and not 0. Can
you
re-describe the process you are following in detail.

Mangesh

"Freshman" wrote in message
...
Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell,
the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do
with
the paste link so that both the source cell and pasted cell are also
equal
to
"". It is because I want both cells are equal to "" at the very
beginning.

Thanks in advance.