The data from Access is probably text whereas the data you type into the
cell is
a number, copy an empty cell formatted as general or number and select all
the imported numbers, then do paste special and select add. That will force
any numbers formatted as text to turn into matching numbers.



--


Regards,


Peo Sjoblom


"Bob1866" wrote in message
...
Hi, If I type a value into the cell which is the reference for the Vlookup
i
get the error "#N/A" yet if i copy and paste the same number from the
lookup
column into the reference cell it works perfectly, I am guessing that
somehow
there is a formatting issue with the data that comes from the database
(Access) and Excel I am just not sure what it is, I have pasted the data
into
Notepad to see if there is anything added in the formatting but it is
still
exactly the same as I typed. But if I then try and copy that back into the
reference cell I get the same error. Just wondering if anybody has got any
ideas how to fix this annoying problem.

Many Thanks

Windows Xp pro
Office 2003