Change Decimal separator

[timlucas]

Hi,
Is there a way to change the deciamel separator?
Jamovi uses a dot(".") as a decimal separator, I want to use a comma (",") as the separator.
If I want to export my deskriptive table into Excel to work with it, some values are interpreted as high values, because Excel interpretes the point as a thousend separator (for example: 3.908 is interpreted as 3908). In some other cases Excel imports the point as the decimal separator and I can simply search and replace the dot for a comma.

[jonathon]

hi,

we don't support this feature at present.

jonathon

[reason180]

Just an FYI. You can change Excel's settings so that is uses the dot as the decimal separator:

https://support.microsoft.com/en-us/off ... bb9837bd1e

[yurismol]

I have no desire to break the entire Excel ecosystem that is set up to officially use the comma in all documents.

In R I do this in one line:
options(OutDec=",")

Why is it so hard to implement this little thing in Jamovi?

Countries using decimal comma:
https://en.wikipedia.org/wiki/Decimal_s ... imal_comma

[yurismol]

The absence of Excel among export formats is a separate issue.
This is also one line solved issues about decimal delimiter:
openxlsx::write.xlsx(data, file="test.xlsx", ...)

[reason180]

Using jamovi's Rj module you can simply write some R code like:

Code: Select all

setwd("c:/Temp/")
write.csv2(data, "ToothGrowth.csv")

Note that write.csv2 writes semicolon-separated values and uses the comma as the decimal character. The resulting file opens properly in Excel when Excel has been configured to use the comma as the decimal character.
.

csv2.png (84.36 KiB) Viewed 196 times