Would it be easier to change the data in the VLOOKUP table.
Otherwise change the first cell in your table and then use format painter to
change the rest.

HTH
Michael M

"Kashif" wrote:

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