First make sure the text has no extra blanks or special characters.

Then enter 1 in an un-used cell, copy this cell and paste/special multiply
over the cells you want to convert.
--
Gary's Student


"Hawksby" wrote:

I am currently exporting data from Excell from a system that i use. When i
look at the data the numbers are stored as text. Despite everything i cannot
the data to a number format. Any ideas?

P.s i've tried copy and special pasting formats etc. Also data stored as a
number cannot be changed into text.