text to columns as text rather than date

[cmb80]

Hi there, I am using text to column function via VBA - when record the macro i select "text" rather than "general" which works just fine. However when i run the macro from vba - it presets to general and therefore displays my split data as a time rather than as text

[mrice]

Suggest that you check the value of the FieldInfo array in the code.

Please Login or Register  to view this content.

The number 2 should be the second element of the array for which the first element is theindex of the column in you parsed data set (2 in this case).

[cmb80]

Hi there, the problem i have is that for some reason it converts 00:01 to 12:01.

So when i split the columns I get 12 (in column B) and 1 (in column C) - where this should be 0 and 1 respectively