Excel csv VBA turn off autoformatting

[LNG2013]

My csv has some values such as "1/1" or "4/5". These represent 1 out of 1 or 4 out of 5. When my VBA script opens the file and does it's magic, Excel automatically changes these values to 1-Jan or 5-April. How do I disable Excel from formatting my csv data?

 

[Comfy]

When you import the file into excel you should be able to set the column type to Text

A quick recording:

.TextFileColumnDataTypes = Array(1, 2, 4, 9)

1 is General
2 is Text
4 is Date
9 is ignore.

/Comfy