Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have setup several scheduled reports (.xls attachments) to be deliver via email exported each day to my OneDrive. I am using Power BI to connect to these .xls files. The number format of these reports are "custom". Power Query / Power BI cannot recognize this number format. I need to be able to adjust from "custom" to (currency, general, etc...) inside of QuickBooks Online.
Is this possible?
Thanks for bringing this up to the Community space, @Tekell. Let me guide you in adjusting the number format in QuickBooks Online (QBO).
Changing the number format can be done in two different ways in QBO. You can change it in the Account and Settings and the report itself.
You can follow the steps below to navigate the Account and Settings in your account.
On the other hand, if you want to alter the number format in the report, it will depend on what type of report you're trying to open. If the report you open doesn't have the Customize feature, you can switch to Classic View to access it. However, by doing this step, you can't revert it, and the report will remain in the Classic view.
Moreover, you can visit these articles to manage custom reports:
You can send a reply if you have other concerns with adjusting the number format or any QuickBooks-related inquiries. Our team is always here to help and provide the support you need. Have a great day ahead!
Thank you for your response. However, those solutions don't seem to resolve my issue. After the reports are exported, the numbers have "Custom" number formatting in excel.
Greetings, @Tekell. Thanks for the response.
I recognize the importance of being able to customize and set your report number format in QuickBooks Online. Let me share some information that could help you get through this.
If you want to set up a report number format, it's best to seek help from your IT personnel, who can guide you through the process of configuring the data in Excel. You can also contact the Customer Support team of Power Query or Power BI for assistance in troubleshooting any file recognition-related issues. They will be able to provide you with detailed information and help you resolve any problems.
In addition, I'll be leaving this article about reports that you can use in the future:
You can visit and post anytime in the Community forum if you need more help setting up your report number format. We're always pleased to assist you anytime.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here