I’m using an Excel 2007 workbook. That has links to different sheets within workbook. How do I eliminate a “0” in a target link if no data was entered from source?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
How do I eliminate a “0” in a target link
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » How do I eliminate a “0” in a target link
- This topic has 14 replies, 5 voices, and was last updated 15 years, 5 months ago.
AuthorTopicWSababenchrist
AskWoody LoungerNovember 8, 2009 at 11:43 am #463702Viewing 4 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
WSababenchrist
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSababenchrist
AskWoody Lounger -
WSababenchrist
AskWoody Lounger
-
-
-
-
WSVegasNath
AskWoody Lounger -
WSababenchrist
AskWoody Lounger
-
-
WSVegasNath
AskWoody Lounger -
WSababenchrist
AskWoody Lounger
-
-
WSVegasNath
AskWoody LoungerNovember 8, 2009 at 2:05 pm #1184761I assume that either A24 and/or AP24 contains “”.
AFAIK, you cannot calculate a range that contains “” text values.
Another approach which may better suit your needs is to use conditional formatting to make the zero results invisible, well not invisible, but the same font colour as the cell background. This would be instead of the If statements presented earlier.
Post back if you need further guidance.
-
WSababenchrist
AskWoody LoungerNovember 8, 2009 at 2:16 pm #1184763 -
WSBilasTasol
AskWoody LoungerNovember 10, 2009 at 6:22 am #1184892Thank you Nathan
That’s what I will do then,
In cells A24 and AP24 and target cell (AW24) I’ll use conditional formatting that will display “0” with same color as fill color for that cell, this will give the illusion of invisibility. I like it thank you.An alternative (doing away with the need to apply conditional formatting to each relevant cell) is to change the setting for the whole sheet to not show zero values.
Click the Office Button/Excel Options/Advanced. Scroll down to the ‘Display options for this worksheet’ section and de-select the ‘Show a zero in cells that have a zero value’. This setting only applies to the active worksheet.
-
WSababenchrist
AskWoody Lounger
-
-
-
-
WSScottMcNay
AskWoody LoungerDecember 8, 2009 at 9:31 pm #1189953Another way is to change the format. Right-click on a cell, Format Cells, Number tab, Custom. enter this:
General;General;;@
Note the space between the 2nd and 3rd semicolon. The first item is for positive numbers, the second is for negative numbers, the third is zero (we’re indicating to show nothing for zeroes), and the 4th is non-numeric items. In this case, we want nothing if zero. Custom number formats can do some interesting things.
With all of the solutions provided, you will have a problem if you really do have a zero to display. The workaround for that would be to create a user-defined function or macro. With a UDF, you could analyze the origin cell to check for sure whether it’s really a zero, and if so, display a zero in the target cell. With a macro, you could have it activate automatically whenever a change is made, and make the same adjustment if needed, without having to change any formulas in the cells.
–Scott.
Viewing 4 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
AI coming to everything
by
Susan Bradley
34 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
2 hours, 45 minutes ago -
No Screen TurnOff???
by
CWBillow
3 hours, 7 minutes ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
3 hours, 40 minutes ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
15 hours, 17 minutes ago -
How well does your browser block trackers?
by
n0ads
1 hour, 34 minutes ago -
You can’t handle me
by
Susan Bradley
5 hours, 59 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
1 hour, 3 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
1 day, 2 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
6 hours, 9 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
1 day, 3 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
1 day, 3 hours ago -
Lumma malware takedown
by
EyesOnWindows
15 hours, 24 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
1 day, 11 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
1 day, 11 hours ago -
Meet Gemini in Chrome
by
Alex5723
1 day, 15 hours ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
1 day, 16 hours ago -
Trump signs Take It Down Act
by
Alex5723
2 days ago -
Do you have a maintenance window?
by
Susan Bradley
4 hours, 43 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
1 day, 2 hours ago -
Cox Communications and Charter Communications to merge
by
not so anon
2 days, 3 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
11 hours, 44 minutes ago -
hibernate activation
by
e_belmont
2 days, 12 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
2 days, 16 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
2 days, 19 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
2 days, 19 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
1 day, 15 hours ago -
Out of band for Windows 10
by
Susan Bradley
2 days, 23 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
3 days, 6 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
3 days, 14 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.