I have two file test1 and book1, in book1, I vlookup in test, for example, 500016433 should get -1, but now it is not, how to change column M in book1, so we can get value from test?

test, book1 is as follows



if I manually put value 500016433 in the vlookup, it is working, so i guess I need to change colmn M format, but how to change, I have around 2000 records, I don't want to change one by one

Attached Images

	test.PNG (78.7 KB, 13 views)
	book1_1.PNG (84.1 KB, 12 views)
	book1_2.PNG (75.2 KB, 12 views)