Data Type Problem

Giganews Newsgroups
Subject: Data Type Problem
Posted by:  robbyp
Date: Thu, 26 Mar 2009

I have been searching for a long time to find an answer to this and nothing
has come up yet.....

I have a column of data that consists of both numeric and text values. On a
separate worksheet I have data that is all text. I am doing a vlookup to
bring in values to the first worksheet for data. I get a lot of #N/A values
when I do this for one reason:

The numeric data type value will not lookup its equivalent as a text data
type value. Even when I change the numeric data type to text, nothing
happens......until I double-click the cell and then click off of it. It THEN
seems to become text and the #N/A changes to the accurate lookup value.

I've tried everything to find a quick way to get this to work as it's a real
pain to double-click each cell and then click off for the vlookup to work. I
would really appreciate some help. Thanks.