VBA .numberformat="@"

[Robert Evans]

Does anyone know how to fix this?

I have two values in delimited file
133-145 and 7-60

when I apply .numberformat="@"
133-145 works correctly

but 7-60 becomes 22098 which is the date value for July 1, 1960

Is there anyway that I can stop this from happing?
I really need it to stay 7-60

btw: these values do not have quotes around them and I do not have control of the incoming data format

thanks much for any help here

 

[shg]

If you can't control the import (which would be a better solution), then you can use a formula in another column:

=text(a1, "m-yy")

Then copy and paste values over the original column.

 

[Scott Huish]

Set the column as Text, when you do the import.