i have several cell formulas which use if functions and return “”. The problem is, when I copy the data and paste as values into a new workbook, the blank cells appear as 0. Ideally, these would just appear blank/empty. Is there a way to prevent this?
It it also occurs with cell references. For example:
sheet1 has name in column A, address line 1 in column B, address line 2 in column C
sheet 2 has cell references to display the data from sheet 1 in different columns
such as =Sheet1!A2, =Sheet1!B2, etc.
if address line 2 is blank, it will display 0 when copied into a new workbook.
is there a way around this? I don’t want to simply hide the zeros. I’d like blank cells to remain blank.