View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PeterB PeterB is offline
external usenet poster
 
Posts: 11
Default Converting to Number for V Lookup

I am attempting a V Lookup which involves Employee ID#'s, of which some begin
with a Letter (A123) and some begin with a Zero (0123). When I attempt to
convert these to Numbers I see no change and my V Lookup returns a #N/A
error. Any suggestions would be greatly appreciated.

Thank you