Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

× WooPrice Calculator PRO

WPC doesn't recognize comma format from Excel sheet for prices

More
2 months 2 weeks ago #2190 by Veronika Zinsser
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.

Thank you!

Please Log in or Create an account to join the conversation.

Moderators: david
Time to create page: 0.176 seconds

Cart

Total : 0.00 €