Why are all psp references ending on a 0?

When opening one of the financial reports CSV files in Excel the psp reference numbers might end up ending always in a zero. Excel is detecting the 16 digit psp reference number as 'scientific' number resulting in incorrectly displaying the number. This can be easily resolved:

  1. Choose File >> Import
  2. CSV File
  3. Select your file
  4. Choose Delimited
  5. Choose 'Comma' as delimiter 
  6. Define the psp reference column as 'text'
  7. Finish 
Was this article helpful?
6 out of 9 found this helpful