Total : 0.00 €

WPC: Changing the price and changing numeric fields format

If you see wrong formatting while you are uploading your Excel file on WooPrice Calculator, never mind and please go ahead because there are numerous ways provided which allow you to change the price and numeric format after you have uploaded your Excel file.

- Changing the price format

If you want to change the price format, you have to change the WooCommerce price format:

  1. From your Wordpress back-end click on "WooCommerce"
  2. Click on "Settings" 
WooCommerce Price Formatting

You'll see:

  • Currency: Set the currency sign you want
  • Currency Position: The position of the currency
  • Thousand Separator: The thousand separator
  • Decimal Separator: The decimal separator
  • Number of decimals: The number of decimal digits you want to display

 

Click on "Save changes" to save settings.

- Changing the Input Numeric Fields format

Input Fields

You can change the numeric format of the input fields by setting the properties on the Numeric Fields. Let's see how to do that:

  1. Click on "Woo Price Calculator"
  2. Click on "Fields"
  3. Create a new Input Numeric Field or Edit an existing one

From the field form, you can set:

  • Number of Decimals [Default is 2]: The number of decimal digits you want to display
  • Decimal Separator [Default is . ]: The decimal separator (For example . or ,)
Input Fields Formatting

- Changing the Output Numeric Fields for numeric format

If you want to format the output of numeric fields and you've mapped your Output Field with an Excel cell containing only raw numbers you can:

  1. Click on "Woo Price Calculator"
  2. Click on "Fields"
  3. Create a new Output Numeric Field or Edit an existing one

Set Number of Decimals [Default is 2], Thousand Separator and Decimal Separator [Default is . ] on the Output Field Form.

Output Field Format

- Format Output Numeric Fields for price format

To format your output fields for the price you could simply use Excel functions. If you have price on B8 cell, you can format in "0,00 $" using the function: "=TEXT(B8;"0,00 $")"

Output Fields

 

Cart

Total : 0.00 €