I have two sheets, and a vlookup to pull a contact name from one based on a 6
digit number. I get an N/A error all the time. BUT if i manually cut and past
the lookup value into the other sheet and overwrite the same number, the
formula works. I have tried copying formatting from one to the other etc etc
and it still won't work unless i copy the number across. Both files are the
same version. If i copy the number to get it to work, but then overtype with
the same number, it fails again !

Any ideas?