Sounds like your number are not numbers, but text.

Re-format all to General then............

Copy an empty cell and select the column in question and EditPaste
SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Thu, 31 Aug 2006 06:39:02 -0700, guy12345
wrote:

Hello. For last 2 days I've been encountering a problem I have never seen
before. When I'm writing a function, for example a Vlookup. I get a N/A error
from one of the function arguements as it relates to the column I'm
refrencing. The column is formatted as a number however when I re-enter the
number the error goes away. This would be fine except I work with a lot of
records and it is very time consuming to keep re-entering all the numbers in
the column when their already there. Does anyone know what might be causing
this or how to fix it. I would really appricate any help you could give.
Thanks in advance.
-Ian