Reading text as a number

Hi, I need excel to read a cell of text as a number basically.  More detail:  Sold column is where I put the last name of customer.  After several "sold columns" (that's the heading) I have a total s...