Do While Run Type Error 13 When hits #N/A

I am stumped. The code below works fine until it hits the "#N/A". It then gives Run Type Error 13 Type Mismatch.
The column with the #N/A has been converted from vlookup to values so wouldn't it just be a string like the rest?
Why is it doing that and how do I stop it?

    lRow = Range("B1").End(xlDown).Row
    Do While Left(Range("C" & lRow).Value, 1) = "0"
        Range("B" & lRow, "C" & lRow).Delete Shift:=xlUp
        lRow = lRow - 1
    Loop

01150	#N/A
01152	00048
01154	00014
01155	00013
01156	00012
01157	00010