Hi guys,
As i wrote in the title, i have a list of numeric codes that i copy paste from a file to another. It has supposed to lookup for those values in another sheet and the return the result.
Everything fine.
It has work for long time..but now no more.
I discovered that, if i put the symbol ' before those numbers and the press Enter, so the i got the "green triangle" on those cells, and it works!
I tried to convert format and all those stuff but with no results.
Now my problem is that every day i have to select, put ' at the end of the codes and press enter..for about 1500 lines, daily.
Has anyone any solution to this?
Thanks a lot and do not hesitate to ask for more info.
As i wrote in the title, i have a list of numeric codes that i copy paste from a file to another. It has supposed to lookup for those values in another sheet and the return the result.
Everything fine.
It has work for long time..but now no more.
I discovered that, if i put the symbol ' before those numbers and the press Enter, so the i got the "green triangle" on those cells, and it works!
I tried to convert format and all those stuff but with no results.
Now my problem is that every day i have to select, put ' at the end of the codes and press enter..for about 1500 lines, daily.
Has anyone any solution to this?
Thanks a lot and do not hesitate to ask for more info.