How to set up excel output for multiple countries
We have multiple countries in our JDE instance.
For EU countries, they use comma as the decimal. So when JDE create CSV with comma delimited character, excel will format the nubmer incorrectly.
We plan to change it to ';" instead of ',' for the delimited value. But it creates problem for US users since most of the txt file delimited value is using comma.
Any idea how to set up comma delimited value separately based on the country/language set up?
Thank you
Vic