I have a field called PartNumber in a query. Using the query I"m trying to extract the number in front of the text. When I try to extract the number in the string using the VAL() function, I am getting unexpected results. It is thinking that the text string of the part number is an exponential number for the numbers with "E" in the string, but for some reason, it is also doing the same to "D". Funny. How do I apply the VAL() function without it assuming it is exponential for these parts?
See the data below: