0 Appears for Linking Blank Cells

I am linking several cells in Sheet1 to other sheets throughout the workbook. Sheets2-10 to be exact. The problem is when no data is in a given cell in Sheet1 a '0' shows up on the linked cell in Sheet2-10. The problem is 0 can be a correct response sometimes and if 0 is always to show up someone is going to misunderstand the task.

I just want to stop blank entries from being linked over as 0. I have a ton of cells being linked and don't want to do conditional formatting on each individual cell. Is their any easy way to stop this?

I wanted the cell in Sheet2 (where data was linked not to say 0) so I used this code:

=IF(Sheet1!$B$4="","",Sheet1!$B$4)

However I got an error message that reads: You may NOT use references to other worksheets or workbooks for Conditional Formatting Criteria"

What is this all about? Is my Excel not setup right or something?

I was mistakenly putting the formula into the conditional formatting.

One last question. I was able to get rid of the 0s with your code. However, this wasn't a problem with another workbook I have. In that case, when nothing is entered into a cell, a dash mark appears '-' which is perfect! I can't seem to figure out for the life of me why 0s appear when I try to link data (and this results in having to add that one line of code in a lot of places!). Any idea?

Thank you for all the help so far.

Last Workbook
==========
1.) Data in Sheet1 was linked to Sheet2.
2.) In Sheet1 where cells were blank, they appear as '-' in Sheet2.
3.) No code was found to do this.

Current Workbook
=============
1.) Data in Sheet1 is linked to Sheet2.
2.) In Sheet1 where cells are blank, they appear as 0s.
3.) However, I could change this with your code.


Any clude how the heck this was done without code? Were the settings modified or something?

1.) Look at the highlighted cell on the Input worksheet. It has the value 1.22. If you go over to the Lebonitz worksheet you will see it is there 1.22.
2.) However, if you delete 1.22 from the Input tab a "-" appears on the Lebonitz worksheet instead of "0". How was this done?

Thank you so much!