Using OpenText(.... problems with formating

[GO2]

Hi, I am using the OpenText method to open a .csv file. I have added a column that has values like
"05"
"05,06"
"06"
""
etc. I need excel to see the values as CHARACTER/STRING, not as numbers. When I look at the value, it has been converted to

5,0000000000
5,0599999999
6,0000000000

How can I get it to read it without doing the formating stuff??

Geir Otto

 

[Domski]

You could record a Macro opening the file with the text import wizard and it should give you the syntax for you opening the file as you want the data to be formatted.

Dom