Thread
:
Numeric data being ignored
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
Numeric data being ignored
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.
.
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge