is this for display purposes of use elsewhere
ie do you actually want to set the value to be "" or just see the value as ""?
if the latter than using a cusotm format may be the smartest approach
its the third term that says effectively if 0 then display as ""
if you need to physically remove the 0 then you'd probably need to write some VBA code and run it as a macro
My Excel is very rusty
but you'd need to work out what the range of cells you were going to examine
then for each cell check to see if its a 0 value and if so set that cell to ""