Export to excel - leading zeros

drcoder · ‎November 15, 2019

I'm using QuickBooks Desktop for Mac and trying to export a report (for example "sales by customer detail") to excel. The behavior i'm seeing is that if a particular field has a number in it with leading zeros (for example "012345" to "00324234") that field becomes a "number" in excel and the leading zeros are deleted, making the field value be "12345" and "324234". Changing the cell formatting in excel doesn't help.

Has anyone else ran into the same issue and has a solution?

Thanks

BettyJaneB · ‎November 15, 2019

Hi there, @drcoder.

QuickBooks Desktop for Mac will eliminate the leading zeroes on the transaction numbers when exporting reports to Excel. These figures will show up if you export the report from QuickBooks Desktop for Windows.

To include the zeroes on the spreadsheet, you'll need to enter them manually.

I can see the importance of this ability in your business. This is why our developers are aiming to improve the product and to provide you the best customer experience.

I encourage you to visit the What's New section on your QuickBooks to stay current with our news and updates. Just click on the Help menu then select What's new with QuickBooks.

Reach back out to me here if you have any other concerns. I'm always ready to lend a hand. Have good one!

Topics

Training

Community

Resources

Export to excel - leading zeros

Export to excel - leading zeros

Need to get in touch?