When I attempt to export a report (Balance Sheet) to excel, I get the account names and format but only zeros for numbers.

Glad to hear that you were able to export the Balance Sheet report successfully, @gayle_graham-yah.

Since you have challenges when viewing the numbers from Excel, we can perform some steps to fix it.

Make sure to click the Enable Editing button so all the numbers will show up. 

The result after clicking the Enable Editing button:

I've gathered some articles about managing reports in QuickBooks Online (QBO):

• Customize reports
• Memorize reports

Stay in touch if you still need help with this matter. I'm here to continue to assist you anytime. Take care and have a good one, gayle_graham-yah.

@SarahannC, clearing caches only applies to display issues in browsers, not in excel

Thank you for clarifying this, @my-answer-is-nonsense.
 

Rest assured, I'll let my colleague update their response and get this resolved as soon as possible.

If you require assistance with QuickBooks Online (QBO), please include it in your response. I'm always willing to lend a helping hand. Have a fantastic weekend!