cancel
Showing results for 
Search instead for 
Did you mean: 
system
Level 3

touble: zero has camma so that formula can't work well

I use QB desktop 2018.

When I export report of PL Budget vs Actual to excel file, the excel file has camma in zero so that formula can't work well. Please refer the attached file.

Could you help me how to solve it?

 

 

2 Comments 2
TirzahC
QuickBooks Team

touble: zero has camma so that formula can't work well

Thanks for reaching out to the Community today. Let me provide you with some details about exporting an excel file in QuickBooks Desktop, system. 

 

Based on the error message, it seems like it has a comma in zeros in your excel file. To isolate this issue, you can follow steps 1 to 5 in this article: Fix export to Excel issues in QuickBooks Desktop

 

If you want to learn more about what you can export to excel, check out this article: Import and Export to MS Excel. You can also refer to this link to explore all your options for managing your data: Import and Export Data.

 

Lastly, feel free to read this guide to know more about the available reports in QuickBooks Desktop: Understand reports.
 

Please know that the Community always has your back, so don't hesitate to let me know If I can be of any assistance. Feel comfortable to tag me in your comments.

system
Level 3

touble: zero has camma so that formula can't work well

TirzahC san

I'm sorry for late reply and thank you for your comments.

I'll share the links you gave me with staff facing this problem.

 

I'll update.

 

Thank you

 

Need to get in touch?

Contact us