I have a database that drops data into a spreadsheet column. When the data comes in it is all values but in text format 3,5,25,1 etc.. When I sum the cell values it returns 0 instead of adding the values because it sees them as text. What I need is a macro I can run to go down the entire colum and convert from text to real numbers.. any help??