Forum Discussion
EstherGrandal_D
8 years agoQrew Cadet
Thank you Megan for your help, I have been reading it.
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?
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?