csv converting last 4 numbers to 0000

  • Travelops
    Asked on February 1, 2016 at 5:16 AM
  • victor
    Replied on February 1, 2016 at 9: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