Want to see as numbers not text

[chrisdtran]

Thanks Julie
I tried that but that did not help! The problem seems to be from th
formula with the Vlookup function that looks into the empty cells an
returns the none-number values

 

[JulieD]

Hi

sorry, missed the "obvious" ... replace the "0" in your formula with simply
0
e.g.
if(iserror(vlookup(C1,A1:B6,2,false),0,vlookup(C1,A1:B6,2,false))

Cheers
JulieD