Text Treated As Number

[KHSDM]

I have some product codes that are text, but treated as number/integer. Anyone know why?

The codes:-

7E02
8E12
7E22
8E32
8E36
8E42
8E46

Other codes in the same field are treated as text. Only the above are treated as number. (right aligned)

[tresB · Accepted solution]

'E' is being treated as 'Exponent' (scientific notation). If you want this to be treated as text, try loading like:

Load

        Text(Field) as Field