Suppression Of Zeros Even In The Middle Of Number Fault

I have a large excel spreadsheet which looks at a number of test results for students in school. The worksheet being prepared by marcos to display different class results dependent on the teacher select so they can view their class data. The sheet works fine and does all I need but have a fault with the transfer of test results which contain zeros. These are transfered with the zero missing even if the zero is in the middle of the number eg 203. The display if zeros is not suppressed and I have no format to suppress zeros but also understand these commands on suppress empty cells containing just zero.

This code will bring up the fault shown above and will loose zeros so 10 on source sheet becomes 1 and 102 becomes 12

VB : =IFERROR(SUBSTITUTE((VLOOKUP($A11,INDIRECT($H$14),550,False)),"0",""),"")

I wondered if the SUBSTITUTE command is causeing issues but cannot remember quite what this command does - may have copied from elsewhere and not fully understood it.

The following code is used elsewhere on the same worksheet to display the same test result but in a individual pupil format rather than as a class sheet.

VB : =IFERROR(VLOOKUP($C$7,INDIRECT($H$14),888,False),"")

This picks up the same result but does not suppress the zeros. It cannot be used to do the job of the upper code as it reads from the original source where as the upper line of code reads from a central point which does not change so the data from 6 different areas is copied into this area.

These are not part of macros just in a cell. The cells are not formatted and then right click format cell is just "general".

Needless to say I need to know what I have done wrong to get the test result to be displayed incorrectly so I can correct it to get the sheet right.