Trying to convert text entries to a numerical value

[Rickwelsh]

I have a column of 20 cells. Each cell can have 1 of 10 possible entries. Each entry has a numerical value.

I am having trouble building a formula to search a table with this information to assign the numerical value to the entries.

[#2]

@Rickwelsh The numbers were probably entered as text or the cells were formatted as text before you entered the numbers . First make sure that the column is formatted as Number. That may resolve the issue. If not, try Text-to-Columns (TTC) on the Data ribbon. Select the column of numbers, select TTC and select Finish. If that doesn't work either (and since you only deal with 20 numbers), I would just select each cell, press F2 and Enter. That takes about 15 seconds and you are done.

[#3]

@Riny_van_Eekelen 

Riny,

I solved the problem using the LOOKUP function. I built a 2 column table with the text values in one column and the numerical values in the second column. I compared each survey item to thevfirst column and the software found the numerical value in the second column.

Thank you for your suggestion.

It worked nicely. I just pastef the formula into 

K

UP