Is there a way to make Excel recognize a number in a cell with text as a number? Therefore I can use it in an AutoSum? Basically I want to keep the number with the text because I use the same names frequently and want to keep the ability to use the autofill (not sure if that right but its when you type the first few letters it autofills out the rest of the word/words for you.) But I also would like to sum up the numerical values in those cells. Thanks.