4 ms·
Everyone knows how to wrestle Excel into cooperating, but that's the point - you shouldn't have to. I would posit there's a near zero likelihood that someone c
by Alupis 4y ago
Everyone knows how to wrestle Excel into cooperating, but that's the point - you shouldn't have to.
I would posit there's a near zero likelihood that someone copy/pasting a, say 21 digit number, wants it to automatically convert to Scientific Notation and lose data.
Excel should do the least astonishing thing when someone is working with data. If it cannot handle 15+ digits, it should assume a string, not a broken number.
- scantis 4y agoCheck out EXCEL induced genome renaming. Like the northern star, a refusal to waiver under any persuasion.
- FunkHose 4y agoThen you’d have someone complaining they can’t perform math on the numbers they just posted into Excel.
- thfuran 4y agoThere is no universally least astonishing thing for something with usecases as varied as excel. But I suspect that treating numbers as text is close to maximally astonishing.