Too fast with the send button.

The custom format of # will hide the zeros but not show decimals if your
blank source cell becomes a number like 123.45

Rather than pasting links it is better, not easier, to use a formula like

=IF(Sheet1!A1="","",Sheet1!A1)


Gord

On Mon, 16 Nov 2009 12:42:53 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Format as Custom

Type the # sign only


Gord Dibben MS Excel MVP

On Mon, 16 Nov 2009 12:37:22 -0800 (PST), Doug Howell
wrote:

Changing the cell to number doesn't work.
It still shows "0" in the linked cell.