Can CSV export be adjusted to use a comma for decimals? (as is commonly used in Europe)

jbyrne · 2020-01-31T15:08:55+00:00

When I export a widget into CSV the decimal place is a "." and since my laptop was setup in the UK my Excel can read this perfectly well and calculations can be performed without making any changes. However, our program has a lot of users in Europe where the "," is more common and so when they see "0.8321" (for example) their Excel doesn't recognise this as a number - it is expecting "0,8321". It's probably not realistic to suggest they change their global Excel settings since I imagine in any other context all numbers will come in the expected format. Is there anything within Qualtrics that can change the format of the number? I imagine customers have faced this issue before?

Can CSV export be adjusted to use a comma for decimals? (as is commonly used in Europe) | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded