France locale - issues with commas and spaces when exporting to Excel
For a user with French locale, Standard Reporting exports data as follows: 1 234,40
This is the expected behavior in Zuora and is formatted correctly for French numbering standards.
However, the number is not recognized properly by 3rd party programs like Excel. To allow Excel to recognize the numbering, we need to manually change the locale of the computer to have "." as decimal seperator and we must replace a Space with a 'blank'. Then, the data can be used.
The above process is an annoyance for the customer. We need a consistent system that can allow the user to export their data w/o having to manipulate it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.