EXCEL 2003
Competition and competitor data is a data array A2..L50.

Col A is a sequential number list (fully populated)
Col B contains either character "S" or is blank (90% blanks)
Col C is a names list (fully populated),
Cols D..L contain either character "X" or a blank (65% populated) -these are the 9 competitions. "X"'s indicate the entrants

I need NINE filtered lists of entrants with 3 elements, one for each competition.

First list is in Cols M..O, but it's printing Zero's, not blanks, in Col N when the value is not "S". Same problem will undoubtedly exist on the further 8 lists!
Formulae -
Cell M2 =IF(D2="X",A2,"") correctly returns either the number or is blank
Cell N2 =IF(D2="X",B2,"") returns either the "S" (correctly) or a numeric "0"
Cell O2 =IF(D2="X",C2,"") and correctly returns either the name or a blank.

I've tried conditionally formatting cell N2 to print the 0 in white, with no success.

Why is Cell N2 returning ZERO's? How can I get it to return a blank?