Linking Cells

[Bookworm]

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?

 

[David Biddulph]

=IF(A1="","",A1)

 

[Tim879]

You could also use the isblank function

=if(isblank(a1),"",a1)

 

[Bookworm]

You could also use the isblank function

=if(isblank(a1),"",a1)

Thanks for info. A question though? you suggest: =if(isblank(a1) etc
what cell does this refer to? where the source is? and at the end you
use the same cell reference a1 what does this refer to and where do I
place the formula in the source worksheet or the target worksheet.
Sorry for seeming an idiot but I am fairly new to anything but the
simplist spreadsheets.

 

[Bookworm]

You could also use the isblank function

=if(isblank(a1),"",a1)

Sorry I am getting mixed up with another posting I have on pasting
cells to the next blank space on another worksheet.

Profuse apolgies.

 

[Guest]

You have to change the formatting

CRTL+1 > custom > 0;-0;

 

[Bookworm]

You have to change the formatting

CRTL+1 > custom > 0;-0;

Thanks to everyone that helped. OK now. Did it via the format way as I
am not yet into code. Taught myself to correct all cells by using a
macro so I have learned two things today.

 

[Guest]

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