Numeric data being ignored

[Anu]

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.

 

[Nick Hodge]

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
(e-mail address removed)

 

[Guest]

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
(e-mail address removed)

 

[Nick Hodge]

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
(e-mail address removed)