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

Home – SaaS Forums Support questions WooPrice Calculator (Pro) WPC doesn’t recognize comma format from Excel sheet for prices

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #6934
    Veronika Zinsser
    Participant

    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!

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.