How can you format a cell to be blank after.....
Posted by Ty Agboola on July 10, 2001 11:31 AM
Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1)?
Posted by Gregc on July 10, 2001 11:41 AM
=if(sheet1!a1 = 0,"",sheet1!a1)
