Exporting an item list to CSV format turns my MPNs into a formula

Thanks for keeping us updated, @SteveJMB. 

I can walk you through fixing the MPN format.

In most cases, you can only enter up to 11 digits per cell, and if you enter more, Excel automatically changes the number format. That's why you're getting an MPN figure of 6.66692E+11 instead of 666692123115.

Make sure to select the Number format to display the data you want. I'll show you how:

1. Open the Excel file.

2. Highlight the MPN column.

3. Click on the number format drop-down.

4. Select Number MPN. 

5. Once done, click on the Decrease Decimal icon until you see the whole number on the column.

If you have additional concerns regarding Excel, I recommend getting in touch with your IT expert or reaching out to the Excel support. This allows them to take a look at your issue further.

I'll also include this extra module to learn about other export ways: Things to remember when you import and export data in QuickBooks Desktop.

Additionally, you can read these articles about keeping track and personalizing reports in QBDT:

• Understand reports in QuickBooks Desktop
• Customize reports in QuickBooks Desktop

Please let us know if this goes. We'll make sure to respond as soon as we can. We're happy to help further regarding data management or QuickBooks. Take the best care!