You need to force Excel to treat the contents of the cell as a text value instead of a number, which it does automatically with blank values.
=A2 & ""
This will force Excel into making that cell reference a text value,
thus preventing the conversion of blanks into zeroes.
