I am importing a table to google sheets with a formula like:

=IMPORTHTML("http://TheServer/FetchBatchData.php,"table",1)

In a web browser I get data that looks like the following:

```

Batch   Batches Mix       Customer  Status
30DE    3       AGPDHIGH  Joe       Sent
30DF    3       KHM100    Nancy     Sent
30E0    1       DEER100   Bob       Sent
30E1    3       KHM100    Ted       Sent

```

My problem is that Google Sheets converts the Batch data (a simple Hex value) to scientific notation when it sees the "E" in the batch. The result is that "30E0" becomes 30 and "30E1" becomes 300. I have tried changing cell formats with no luck. Is there something that I am missing in setting up the formatting or the formula that can get Google to not help me?