One way is to copy a blank cell, then right click on the id col of text
numbers psate special add ok. That should convert it all at one go to
real numbers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"claude jerry" wrote:
I have a Table with foll Detail Which is used for Vlookup (This is created
by spooling data from a software package)

Id Name Date Fee
129 Tom 15/12/07 500
158 Kat 14/11/01 450

The above id's (129 and 158 etc ) are Text values
I.e if I use a test, =Istext(Id Cell) it gives me "True"

Our head office sends me an excel File

Id Name Date Fee
129 Blank Blank Blank

The Id's they sent are in Number format
I used a Test =Isnumber(Id cell) it gives me "True"

I am using a VlookupFormula to fill the Blank information sent by Headoffice
by refering to by data stored in the first table. but since in the Original
table the Id's are in Text format and the Id's in the second table are
Number. Vlookup gives an error.

How can I convert these Numbers to text, or Text to Numbers.

Format Cells Numbers . . .. does not help