On Dec 1, 1:55*am, Max wrote:
One way is to copy a blank cell, then right click on the id col oftextnumbers psate special add ok. That shouldconvertit all at one go to
realnumbers.
--
Max
Singaporehttp://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 ) areTextvalues
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 inTextformat and the Id's in the second table are
Number. Vlookup gives an error.

How can IconverttheseNumberstotext, orTexttoNumbers.

Format Cells Numbers. . .. does not help- Hide quotedtext-

- Show quotedtext-

Any suggestions, resources or perhaps solutions on how I can convert
text into numbers on excel 2007? I have a column on my excel sheet and
it has the text "Positive" and I want to convert that into 1?