Worked beautifully, is there any way of not getting those 0's to not show on
a chart as well?

"Mike" wrote:

=IF(Sheet3!A1<"",Sheet3!A1,"")


=IF(Sheet3!A1=0,"",Sheet3!A1)#

try either of these


"Alex" wrote:

I am linking data from another worksheet, but I want any value which is 0 to
show a blank cell. What would be the easies way to do this?