Veronika Zinsser created the topic: WPC doesn't recognize comma format from Excel sheet for prices
Hello! I hope you have any advice for me:
I need some prices to be shown in this format: 25,00 € in output fields.
In Excel I used the formatting method as written in your blog post: TEXT(X1;"0,00 €") - but unfortunately when I enter the spreadsheet in WPC it is shown without comma. The price is even rounded to full Euros (which is obviously not what I want )
I tried this format: TEXT(X1;"0.00 €") and it worked! But now of course it's shown with a dot instead of a comma. Do you have any idea what I'm missing?
I adjusted price format in WooCommerce and in the fields itselves (but I think this shouldn't matter anyway). The main price is shown correctly, the problem is only in output fields.