Ron now says ...

the column contains all
'text' datatypes (so it isn't mixed)

But Ron originally said ...

there is
definately data in the cell - a number that I am
converting to a long format.
Sounds to me like something or someone is mixed :-)

Jamie.

--