Win/Loss/Tie Record not formatting correctly

[sportsdude11]

Hello,

Hopefully I can get some help. I am using the Importhtml function to bring in tables that include teams and win/loss/tie records.

When I import then, the Win/Loss/Tie record either comes as a random 5 digit number

Ex. Team A 11-5-0

This is imported as 36835

Some of them work Ex Team B 13-4-0 imports as 13-4-0.

I have tried all the formatting I can think of but it is not working.

Hopefully someone can help.

Thanks,

Justin

 

[jasonb75]

The source format is being recognised as a date in some cases.

11-5-0 = November 5 2000. 13-4-0 works as expected because there is no 13th month in the year.

A custom format of m-d-y might fix it.

 

[sportsdude11]

Jason,

That worked. Thank you