Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
'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
'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