I have a list of 1000 IDs, each ID must be 10 digits long and must be saved as a number. At the moment those which should have 0's at the front are appearing with the 0's dropped, this means that my vloopup on this ID is not working. Is there an easy solution? I know I can save them as text, however, again when I do this the vlooup cannot find the ID.