Page 1 of 1
Change Decimal separator
Posted: Wed Jun 11, 2025 6:39 am
by 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.
Re: Change Decimal separator
Posted: Wed Jun 11, 2025 7:31 am
by jonathon
hi,
we don't support this feature at present.
jonathon
Re: Change Decimal separator
Posted: Fri Jun 13, 2025 3:33 am
by 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
Re: Change Decimal separator
Posted: Fri Jun 13, 2025 5:26 pm
by 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
Re: Change Decimal separator
Posted: Fri Jun 13, 2025 5:38 pm
by 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", ...)
Re: Change Decimal separator
Posted: Sat Jun 14, 2025 1:19 am
by 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 10248 times
Re: Change Decimal separator
Posted: Mon Jun 16, 2025 2:55 am
by yurismol
It might be useful to add write.csv2 to the export formats