I have a excel file with data that i import to other excel
files. Im doning this by using the querytable object.
The problem is that the source file contains text &
numeric data in one column. When this is imported onto the
new file, the numeric data is missing.
How can i force excel to treat the numbers as text.
The import is a part of a series of automated processes &
i need to achieve this progarmatically.

Thanks!
- Anu.

Anu

You could prefix the data with a single apostrophe ('). It won't display but
will transfer all as text. If you do VLOOKUPs or similar on this data it
may be difficult with this route.


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Anu" wrote in message
...
I have a excel file with data that i import to other excel
files. Im doning this by using the querytable object.
The problem is that the source file contains text &
numeric data in one column. When this is imported onto the
new file, the numeric data is missing.
How can i force excel to treat the numbers as text.
The import is a part of a series of automated processes &
i need to achieve this progarmatically.

Thanks!
- Anu.

I have tried the single apostrophe and it does display, am
I doing something wrong. I am creating a file out of our
mainframe comma delimited (.CSV).

Thanks

Adam Goch
Roadway Express

-----Original Message-----
Anu

You could prefix the data with a single apostrophe (').
It won't display but
will transfer all as text. If you do VLOOKUPs or similar
on this data it
may be difficult with this route.


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Anu" wrote in
message
...
I have a excel file with data that i import to other
excel
files. Im doning this by using the querytable object.
The problem is that the source file contains text &
numeric data in one column. When this is imported onto
the
new file, the numeric data is missing.
How can i force excel to treat the numbers as text.
The import is a part of a series of automated processes
&
i need to achieve this progarmatically.

Thanks!
- Anu.


.

Adam

If the file has a .csv extension Excel ignores any settings. Try saving it
without an extension or with a .txt one.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


wrote in message
...
I have tried the single apostrophe and it does display, am
I doing something wrong. I am creating a file out of our
mainframe comma delimited (.CSV).

Thanks

Adam Goch
Roadway Express

-----Original Message-----
Anu

You could prefix the data with a single apostrophe (').
It won't display but
will transfer all as text. If you do VLOOKUPs or similar
on this data it
may be difficult with this route.


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Anu" wrote in
message
...
I have a excel file with data that i import to other
excel
files. Im doning this by using the querytable object.
The problem is that the source file contains text &
numeric data in one column. When this is imported onto
the
new file, the numeric data is missing.
How can i force excel to treat the numbers as text.
The import is a part of a series of automated processes
&
i need to achieve this progarmatically.

Thanks!
- Anu.


.