Avoid converting to date when using TextToColumns

[renatoab]

I have a problem, beacause I import data from text files and some tables come with codes like SEP4, which is converted automatically to date (september 4th).

On Microsoft help pages, one of their suggestions is to put empty space. But it seems to work only when I enter data manualy in a cell. As I use fixed width, I tried to break leaving spaces on the left, but this does not work.
I've already made many things to work this codes, making substitutions, putting characters on the left of the code, but this is not an inteligent way, because I need to treat every case separatelly, and I have many different tables do deal with.

Do you know some way of doing this in a more general and systematic way.

Thank you in advance

 

[Firefly2012]

Hi

If you are using the usernterface wizard then can you not specify the column to be imported as text on the third screen of the wizard?

 

[renatoab]

I'm not using user interface wizard, I'm using VBA.

There is a parameter fieldinfo, where I can specify the data type of the cell. It is not a simple solution for me, because I need conversion to numeric format, but it seems to be the way I need to follow.

 

[Norie]

Try recording a macro when you do use the wizard.

Then you should get code with the fieldinfo you want.

Mind you I don't see how you can convert SEP4 to a numeric format as it's text.