Quick formula: preserve real zeros For a genuinely empty source cell A1, use =IF(ISBLANK(A1),"",A1). If A1 contains a formula returning "", ISBLANK returns FALSE because the cell contains a formula. To treat both true blanks and empty-string results as visually blank, consider =IF(A1="","",A1); test it on real zero values and text before applying across a workbook. Why Do Blank Cells Show as Zero in Excel? In Excel, a formula such… Read More »Excel: Show Blank Instead of Zero When a Referenced Cell Is Empty