Changing the format of a cell (or column of cells) doesn't change the value
within each cell.

That's why things worked after you reentered the value in the cell.

One way to convert lots of these text numbers to number numbers is to:
select an empty cell
edit|copy
select your range of offending cells
edit|Paste special|check add



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

--

Dave Peterson