Hi,

Do the following:

1. On the Tools menu, click Options.
The Options dialog box is displayed.
2. Click the View tab.
3. Under Windows Option
4. Clear the Zero values check box.
5. Click Ok to ste the properties and return to the worksheet.

Challa prabhu

"Bookworm" wrote:

I am linking some Text cells in a worksheet to other cells to
automaticaly link them with Copy/Paste Link.

Even though the source cell is formatted as text the target cell shows
a zero (0) when empty. How do I get the target cell to stay blank?