Stop Excel from assuming data is a date

A work-around solution would be to (after import)

For each oneCell in myRange
    With oneCell
        If IsDate(.Value) Then
            .Value = Month(.Value)/Day(.Value)
        End If
    End With
Next oneCell

Carsto, hello.

You may force Excel to interact with values as with totally stringy ones by adding ' symbol before. Just like in this example:

Cells(2, 1).Value = "'" & Cells(1, 1).Value

I have had this problem as well. When I enter a list of numbers in a AAA1111 format, and a value happens to be something like;
JUN4826 or JUL3892
it turns into
Jun-26 or JUL-92
Which are recognized as the values
07/01/4826 or 07/01/3892
Resulting in the numeric values
1068883 or 727747

Which is really annoying.

One way around it is to format the entire column as TEXT before entering the data, and if copying data from another sheet make sure you Paste Special / Values

OR, you can place a ' before the string

'1/4 will show in the cell as 1/4 regardless of format


Edit: Sorry, didn't notice this was in the VBA section. See above responses!

Speshul, hello.

Don't mind about section, your idea about cell formating sounds good =) Because everything that we might do manually - may be performed by code.

So, by VBA we may change cell formating to text. Could be better to change every single cell, because whole column will eat PC resources.

Cells(2, 1).NumberFormat = "@"
Cells(2, 1).Value = "1/4"

Carsto, o'key, I see then what we might do. May you please attach sample of your TXT file? 10-20 rows with different cases will be sufficient.