I'm trying to import a table from Excel following this question and answers. In doing so, strings are kept as strings though numeric values get interpreted as
Real and some are subsequently rounded. I don't want this rounding to occur.
I think I've identified the fundamental behavior I'm having issues with. One can type (without copy/paste from a spreadsheet) this minimal example:
This pattern repeats throughout the imported table, seemingly when the value is above 10,000.
Is there a simple way to cut/paste from a spreadsheet and not have Mathematica round values? I've created my own methods, but they feel like hacks. (Such as: import the entire table as
String, then do