Currency Formatting (SOLVED)

[Craig Day]

I have a store set up with 4 languages (EN, FR, DE, ES). I want to format all the currencies to use the decimal point as decimal separator rather than comma as is used for French, German and Spanish as this is causing an error relating to Google Merchant Centre. (see image)

Is there any way to format the currencies so that they read €1,234.00 rather than €1,234,00?

When going into International > Location > Currencies then only format choices include the , (see image).

Set-up:

PS Version - 1.7.8.7.

PHP - 7.3.29.

It's probably something obvious that I'm missing.

[Craig Day]

Additional:

When I examine the table PS_Currency_Lang using PHPMyAdmin, It shows as follows (no comma decimal separator pattern for any of the currencies):

Lang ID 1 - EN,

Lang ID 3 - FR,

Lang ID 4 - DE,

Lang ID 5 - ES.

[El Patron]

this post should be useful