Excel fill down showing zero (prefer a blank)
Posted on 2014-02-01
This should be easy!
I have sheetA and sheetB - with peoples names in sheetA - column A.
In sheetB I have set cell A1 to cell A100 as follows : =sheetA!A1 (and A2 etc).
This works fine except that if , for example, SheetA!A8 is blank then this is presented in SheetB!A8 as a zero....
In other words when I copy a blank cell - this results in a ZERO being displayed.
These are NOT numeric fields and I need a blank displayed NOT ZERO.