web query autoformats numbers

P

puppet_sock

Hi

I'm fetching data from a server (the URL of which I've excised
for security reasons) using a web query as below. The problem is,
sometimes the data is something like so:

8264E01

This is supposed to be interpreted as text. I can't seem to find
a combination of settings that causes it to leave that as text.
It always seems to convert that to a number and display it as
8.264E4.

Is there any way to force this to leave it as text?

I've tried:
- locking the formatting but leaving the page editable (the
query refuses to run)
- formatting the destination as text
- various settings in the web query

Any help much appreciated.
Socks

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;REMOVEDFORPRIVACY" _
, Destination:=Range("A1"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = True
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = True
.Refresh BackgroundQuery:=False
End With
 
Top