For example, having "49018e16" in a cell will print "490180000000000000000" in CSV viewer, same with "49018e23" -> "4.9018e+27" for example (why 23 to 27 though, I don't really know).
I agree that those hex numbers don't have the "0x" prefix to recognize them, and the problematic ones only begin with decimal digits, then "e", then decimal digits.
The only possibility to fix this would be to use full column data to determine type, I suppose.
For example, having "49018e16" in a cell will print "490180000000000000000" in CSV viewer, same with "49018e23" -> "4.9018e+27" for example (why 23 to 27 though, I don't really know).
I agree that those hex numbers don't have the "0x" prefix to recognize them, and the problematic ones only begin with decimal digits, then "e", then decimal digits.
The only possibility to fix this would be to use full column data to determine type, I suppose.