Excel query returns numeric only from a column that contains numeric and
text.
The column (cells) is fomated as text.

Is there a way to return all the data from the column by query?

Thanks.
Haji

You might try importing all the data as text then converting to numeric after
it's in xl

"Hajime Kusakabe" wrote:

Excel query returns numeric only from a column that contains numeric and
text.
The column (cells) is fomated as text.

Is there a way to return all the data from the column by query?

Thanks.
Haji

I put a space in front of these fields to make them as text.

Haji


"Hajime Kusakabe" wrote in message
...
Excel query returns numeric only from a column that contains numeric and
text.
The column (cells) is fomated as text.

Is there a way to return all the data from the column by query?

Thanks.
Haji