Exporting a report (GL) in Excel: problem with number formatting

Hi Mouselette, 

Glad to hear from you again. It's vital you get the support you need with this ASAP. 

I appreciate you doing some troubleshooting on your end. At this point, I recommend contacting one of our agents for further troubleshooting. To find the contact details, please click this link here. One of our specialists will be happy to take a look at your account and assist.

Let me know if you have other questions. I'll be on standby. 

Hello James!

Glad to be getting a reply!

I will certainly contact your contact. I am sure I'm not the only one trying to figure this out. W10 can be tricky with certain things...

I'll post back here if / when we figure this out.

Thanks!

Hey there, did you ever find out the solution because on my end I didn't

thanks

Hi,

It seems to be a problem with Windows, Microsoft Office and QB settings that don't "understand" each other.

In my case, I had an increase of workload, so I could not dedicate more time to solve the problem. It is irritating since before I migrated to the 2020 version, that feature worked flawlessly. Now, when I export to Excel, in the box "Send Report to Excel", I click on the "Advance" button, and deselect the Auto filtering option. When in Excel, I select the part with the amounts, and change the format to Numbers, and it seems to work for all amounts less than thousands. For the thousands amounts, I need to remove the spacing between the thousand and hundred for the amount to be taken into account in the calculations. So far, honestly, I only had the patience to export to Excel to do my cashflow. Other reports are longer, and I have no time to remove lines and lines of spaces ...

I don't remember how things are when using the .csv file export... last I used it, it seemed to work, but the formatting is lost...

Maybe someone else had better luck?

Thanks for getting back with further information, Mouselette. At this level, I'd suggest reaching out to Excel's support team for the best advice on how to move forward. 

Here's the contact link to Microsoft: Microsoft Support.

Hi everyone!

It seems like the QB Tool Hub fixed a good part of what was not functioning - give it a try!

Thanks!

Glad to hear that the QB Tool Hub was of assistance @Mouselette! Great work troubleshooting. Drop by any time you have a QuickBooks-related question or concern. Take care.

Hi everyone!

It is finally figured out :-)

The problem is that QB works in English, and my W10 settings were for French.

The resulting reports are in English, and it's a real pain in the b**t since we function in French. But the numbers jive at least...

Have a great day!

Wow... I am not sure how this can happen again... and even the Hub tool cannot fix it!

Since last week, exports to Excel results in numbers having the wrong format ..... AGAIN!!

I tried many of the fixes suggested, but it doesn't solve the problem

I think it may have been an update that started it all, and now... in the midst of pulling the numbers for the T4s and R1s...

Has anyone seen the same problem?

QuickBooks Pro Desktop 2020

Hi Mouselette,

Thanks for getting back to us here.  I can understand how the behavior in QuickBooks Desktop, can impact your day.  I encourage you to contact our Customer Care team at 1-833-317-2226, Mon-Fri: 9am-8pm ET.  They would be happy to work with you in real time and review the issue in more depth, in order to escalate it for further investigation if necessary.

If you have any other questions or concerns, please don't hesitate to reach back out.  We would be happy to help!