Has anyone ever experienced reading data from a Csv file, and some of the data being read as being formatted as scientific notation instead of it's actual text value?
For instance, the value 29670E107 in a cell in the .csv file is getting converted to 2.967E+111 when reading directly from the file using the OpenDocument Spreadsheet action. Haven't tried using Excel to see if it does the same thing, but switching to Excel would be a fairly large task at this point in time anyways.
Has anyone found a workaround for this? I would like to just get the actual text value instead of the scientific notation value.