Web query changing values to dates

Hi everyone,

Long time use, first time poster. Thanks to all who contribute to this forum it has allowed me to delve deep into excel enjoying every minute, but on this occasion i can't find anything to help me and have been racking my brain for weeks.

It seems simple. I run web queries from a web page like this and don't want dates being recognised:

https://www.racenet.com.au/form/hors...te=310117&rn=0

(this will only work for 24 hours)

When i import the data (through vba), it changes some stats like 35:10-4-5 to date formats. I've tried disabling date recognition but it simply changes it the good old 40000 date number.

I've also tried converting all cell formats to text prior to running the query but that doesn't seem to work either.

any help would be much appreciated.

Cheers

Thanks for the suggestion Aardigspook. This is my script below, do you have any ideas on how to add in the character as suggested?

With ActiveWorkbook.Worksheets("Performance").QueryTables.Add(Connection:=performance, Destination:=ActiveWorkbook.Worksheets("Performance").Range("A1"))
.Name = shortperf
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """FormTable"""
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With