In column F, we have a cell whose data comes via = a cell from another sheet in the workbook. The cell in the other sheet is blank, formatted general. When the data comes into the cell in column F, it shows 0. The cell in column F is also formatted general.
Lower in column F, there are cells with 0.00 or other numbers, and we want the zero values to show as zeros, not blanks, so we do not want to untick the zero values box in Options. We tried setting the sending and receiving cells to text format, but that made no difference.
What should we be looking at to make the cell in column F look identical to the cell from which the data came?