Just a quick tip. today i exported a load of a data from phpmyadmin to excell (excell 2007 in this case) and as usual all the data was as ‘text’ instead of being a ‘number’

Having had a detailed (45min) look around the interweb, i was struggeling, they all mentioned methods of converting text to number one cell at a time or using excell 2003-2006 which was useless really.

Anyway, heres how you do it:

Solution
If all your numbers are in the column B, go to column C, right click, and go ‘insert’.
This inserts a new column C, a blank column.
Now in one of the cells type “=VALUE(Cell)” .. eg: “=VALUE(B2)”

Then copy this cell, highlight the rest of the blank column and paste it in so it filles the empty new C column with the correct number values.

Once this is completed, copy all the new C column, and highlight the Previous C column (Column D), right click, and go ‘paste special’ … and you don’t want to paste the function, only the value on the radio box selection.

Voilla.. delete the column c, and now you have converted them all to numeric values.