I'm pasting cells as a link in another spreadsheet. Cells with no value in the source display as a zero in on the destination sheet.
I know I can get rid of zero's in the Tools - Options menu but I don't really want to do this as some values are actually zero and I want these to display.
Does anyone know a way to prevent these blank cells appearing as a zero when linked?
Thanks in advance.
wazoom
I know I can get rid of zero's in the Tools - Options menu but I don't really want to do this as some values are actually zero and I want these to display.
Does anyone know a way to prevent these blank cells appearing as a zero when linked?
Thanks in advance.
wazoom