• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Zeros for blanks in Excel linked cells

by on
in Excel Training,Office Technology

Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?

A. If you don’t have a valid 0 value in a cell, there is an Option under Advanced, you can set for a particular worksheet called “Show a zero in cells that have zero value." It is specific to that workbook and that worksheet in that workbook.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/32007/zeros-for-blanks-in-excel-linked-cells "

Leave a Comment