Excel Linking Cells

sgundrum · 05-16-2005, 09:26 AM

I've got a speadsheet that I want to link cells in. I can link the cells with no problems. What I don't like is the fact that the linked cells contain 0 and I would like them to be null like the original cell until data is entered. How can I do this? I've thought about putting a space in the original cells but that throws off the counting i've got going on in the sheet.

Thanks,

Steve Gundrum

**ReeKorl** · 05-16-2005, 09:38 AM

Hi Steve,

You will need to change the formatting of the cells. Set the format to Custom type and use the following format:

0;-0;;@

This basically says if greater or less than zero, use number, otherwise use blank.

You can find more information about this by going into Excel help and typing "Display or hide zero values"

Another, more long-winded way is to use an if-then-else formula in the result cell, ie:

if(g18=0,"",g18)

Hope this helps!

sgundrum · 05-16-2005, 10:46 AM

Thank you so much for the info. I used to format cells and it worked like a charm.

Thanks Again,

Steve

**ReeKorl** · 05-17-2005, 03:39 AM

No problem, glad I could help!

05-16-2005, 09:26 AM	#1 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Excel Linking Cells I've got a speadsheet that I want to link cells in. I can link the cells with no problems. What I don't like is the fact that the linked cells contain 0 and I would like them to be null like the original cell until data is entered. How can I do this? I've thought about putting a space in the original cells but that throws off the counting i've got going on in the sheet. Thanks, Steve Gundrum __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

05-16-2005, 09:38 AM	#2 (permalink)
ReeKorl Superhuman Computer Join Date: Mar 2005 Location: 6th Circle, The City of Dis, Hell Posts: 1,610 OS: WinXP Pro SP2 My System	Hi Steve, You will need to change the formatting of the cells. Set the format to Custom type and use the following format: 0;-0;;@ This basically says if greater or less than zero, use number, otherwise use blank. You can find more information about this by going into Excel help and typing "Display or hide zero values" Another, more long-winded way is to use an if-then-else formula in the result cell, ie: if(g18=0,"",g18) Hope this helps! __________________ "Sorry, the number you have dialled is imaginary. Please rotate dial by 90 degrees and try again."

05-16-2005, 10:46 AM	#3 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Thank you so much for the info. I used to format cells and it worked like a charm. Thanks Again, Steve __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

05-17-2005, 03:39 AM	#4 (permalink)
ReeKorl Superhuman Computer Join Date: Mar 2005 Location: 6th Circle, The City of Dis, Hell Posts: 1,610 OS: WinXP Pro SP2 My System	No problem, glad I could help! __________________ "Sorry, the number you have dialled is imaginary. Please rotate dial by 90 degrees and try again."