Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

After Importing data into a spreadsheet, the Account Number or Merchant Number is not correct. Why?

April 26, 2017account Data importing merchant spreadsheet

0

Posted

After Importing data into a spreadsheet, the Account Number or Merchant Number is not correct. Why?

1 Answer

0

Posted

These fields, and any other field containing large numbers, must be formatted to be text within the program used to import the data. Otherwise, the program tries to format these fields as integers which is incorrect.