When I export the profit and loss statement to excel all I get are zeros on the screen. when I select the cell and look at the formula bar the value is there.

Hi susanmquesnel-gm,

Thanks for reaching out to us here.  QuickBooks Online provides the option to export your reports to excel seamlessly.  These are exported in 'Protected View', and the amounts will appear as zero, as you've noted.  However, the values will appear when you select 'Enable Editing'.  

If you experience the same result, please contact us for further review of your situation from our end.  

Schedule a Callback or start a Chat: click (?) Help in the upper right in QuickBooks Online > enter "Contact support" > hit Contact Us > provide a brief summary of your situation > hit Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.
Support hours are from Monday to Friday between 9 a.m. and 8 p.m. ET.

If any other questions should come to mind, please feel free to reach back out.  We'd be happy to help!