VBA to convert text to values

[keith]

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??

 

[Mark W.]

Why not select your values, choose the Data | Text to Columns... menu command, and press [ Finish ]?

 

[keith]

I can try to record a macro that does that.. but I am not the user of the sheet so I have to get it done automatically when the user refreshes the database query..

 

[Mark W.]

Why don't you change the database query so it returns numeric data instead of text data?