If I right click on cell A2 and press Format Cells it wrongly tells me that the format is a number. It's actually stored as text. Cell A3 is stored as a number.
However I do want the numbers to be stored as text so I've had to rework some code to make sure that the lookup numbers are also being written to the sheet as text.