I worked it out... I used a if cell = 0 then return "0" formula.. Thanks I think this will work great..