bad-data-guide icon indicating copy to clipboard operation
bad-data-guide copied to clipboard

Published 20 hours ago • verified publisher icon Quartz

text incorrectly interpreted as scientific notation and converted to number

Open krobison13 opened this issue 7 years ago • 1 comments

Excel can interpret a text symbol as scientific notation. For example, if something had the serial code 100E10 this will be converted to 1.0xe12

krobison13 avatar Sep 28 '16 14:09 krobison13

Yep, another good one.

onyxfish avatar Oct 31 '16 17:10 onyxfish