How to stop Datameer from converting excel Text to Scientific Notation

Comments

2 comments

  • Konsta Danyliuk

    Hello Dominic.

    You could to try to save the excel sheet with large numbers as csv file (double check that there is no values in scientific notation in this csv) and import this file into Datameer. If you need these values as strings, choose the type of the column as STRING in Datameer ImportJob wizard.

    0
    Comment actions Permalink
  • Bardele, Dominic

    Thanks, Konsta. I tried going the .csv route but it also moved it to scientific. I found this online and it solved my problem. This issue is closed for me.

    https://stackoverflow.com/questions/13732077/how-to-import-long-number-from-csv-to-excel-without-converting-to-scientific-not

    0
    Comment actions Permalink

Please sign in to leave a comment.