Adding items to list view - blank cells show as 0

Hi everyone, im not very good with arrays, and my listview is populated with an array, but if the cell it fills from is blank, then the listview contains a "0" on final output.

Im not sure if i should test if the cell is "" blank when populating the array, or the listview.

This is how im currently populating my listview.
you will note that columns 13, 12 and 10 have different formats, the column that might contain "" from a blank cell is column 7 and is text. either "DISP" "FLTY" or blank

Please Login or Register  to view this content.

many thanks for your help in advance.

No one know ???

I worked out my sheet was actually storing a 0 in the cell but it was conditionally formatted to white. I changed the Formula to an IF statement to to test if the cell was blank then return blank else return the value.