Has anyone else experienced this issue?
This issue is killing me.
My users complain about the can not convert the data in excels sheets.
Our PCs are set up with EU system, where the decimals are separated by ",",
I know that if I change the computer set up from decimals as "," to decimals "." ( this is the USA system) it works fine with QB, but them my users have issues with the others programs.
I opened a support case and this is what QB sent me. My users in Europe followed the instructions and can now save as a spreadsheet successfully.
"I did some digging and it appears this is an issue with csv files and how they are handled in Excel based on the region settings. If the computer is set to a region which does not use the comma as the list separator, a csv file using commas as the separator will not open properly. Below is a link to a Microsoft help article discussing how to import a .csv file into Excel and at the bottom it walks through the steps to change the separator for .csv files. I have also included another link to a Excel User forum post which discusses this issue.
After the research I am stuck, I do not see the way to let my users to work with coma as decimals and we can not change the set up of all computers because they need to use the EU set up for most of the programs.
let me explain it:
One example; with this report in QB where some fields are set up as come in decimals and other with dots , this way we can see the outcome of the two cases with one report.
If the PC is set up as EU ( comas in decimals) the outcome is that al the data comes in one column all together
This column may be divided in more columns using the wizard (but it not always work fine), it means and extra work (the users do not like it), besides ones you get you data divided in more columns, the numbers that in QB have coma as separator in decimals, now are text ( as you can see the spreadsheet placed quotations marks in the data with coma) so the users need to convert them again to numbers.
If your pc is set up as USA where the decimals are dot
The outcome is that Excel divides the columns but convert the data-number with coma in data-text therefore the user need to pay attention to which fields need to be converted and which not.
I am pretty sure I can not be the first user in EU so it should be a simple way that does not require wizard conversions but I am not able to get it by myself.
Did any other user in EU find out the solution?