I have been fighting this issue for sometime.

If I import HTML data that looks like "1-1" or "4-2" i would like it to
come across treated as text. Then I would take that column and split text to
columns so I could end up with column A/row 1 = to 4 and column B/row 1 = 2
(using the 4-2 example above).

Insteand I get a date conversion for any value that could vaguely look like
a date.

1-1 becomes Jan 1
4-2 becomce April 2

Any ideas how to shut off the automatic date processing?