Thread: VLOOK UP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kashif Kashif is offline
external usenet poster
 
Posts: 8
Default VLOOK UP

I have used VLOOKUP but in few cells it is giving me #N/A in result. I have
noticed that if i change value in a cell from e.g. 111533 to '111533 it
solves the problem but i have more than 800 cells to change.
Is there an easy way to change the format?
Thanks