csv converting last 4 numbers to 0000

  • Profile Image
    Travelops
    Asked on February 01, 2016 at 05:16 AM
  • Profile Image
    victor
    Answered on February 01, 2016 at 09:26 AM

    I am assuming that you exported your submission in a CSV and are opening using and excel sheet. I just reviewed and did notice that when you open a CSV in excel, the last 4 digits of large numbers are replaced with "0"s. When I reviewed the CSV file in a notepad, all the information where correct.

    It seems that there is an issue with excel and large numbers. Please view the following Microsoft page

    https://support.microsoft.com/en-us/kb/269370