Title: String replace
Last modified: September 14, 2018

---

# String replace

 *  Resolved [steveklt](https://wordpress.org/support/users/steveklt/)
 * (@steveklt)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/)
 * Hello,
    I want to replace commas (,) wwith dot (.) for the price column. Is there
   any option to do it or a custom php code? I tried to select Format numbers (use
   WC decimal separator) but nothing changed.

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10687901)
 * Hello
 * >Woocommerce>Settings>General, section “Currency options”
 * Decimal separator = . ?
 * thanks, Alex
 *  Thread Starter [steveklt](https://wordpress.org/support/users/steveklt/)
 * (@steveklt)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10687934)
 * Well, i don’t want to change the decimal for my site because the format 9.999,99
   is more regural for the customers. I would like to make it happen only to the
   exported file because of an obligation of the printing platform that courier 
   provided me and doesn’t recognize commas.
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10687979)
 * ok, please add following code to “Misc Settings”
 *     ```
       add_filter( 'woe_format_numbers', function($new_value, $value) {
         return number_format( floatval( $value ), 2, ".","" );
       },10,2);
       ```
   
 * “Format numbers” must be selected.
 *  Thread Starter [steveklt](https://wordpress.org/support/users/steveklt/)
 * (@steveklt)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10688090)
 * It doesn’t seem to work. I tried changing also decimal seperator but still the
   export file contains commas. Stange though in preview it seems to outpout dot
   but in actual exported xlsx file it is comma.
    -  This reply was modified 7 years, 8 months ago by [steveklt](https://wordpress.org/support/users/steveklt/).
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10688151)
 * Hello
 * Excel uses your OS settings to format numbers.
    But you can change them [https://www.howtogeek.com/245510/how-to-change-excels-decimal-separators-from-periods-to-commas/](https://www.howtogeek.com/245510/how-to-change-excels-decimal-separators-from-periods-to-commas/)
 * thanks, Alex
    -  This reply was modified 7 years, 8 months ago by [algol.plus](https://wordpress.org/support/users/algolplus/).
 *  Thread Starter [steveklt](https://wordpress.org/support/users/steveklt/)
 * (@steveklt)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10688865)
 * Thank you very much! I wouldn’t believe it was from the excel application the
   problem. Your support is awesome.. keep it up!
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10689171)
 * you’re welcome 😉

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘String replace’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

## Tags

 * [decimal](https://wordpress.org/support/topic-tag/decimal/)
 * [string replace](https://wordpress.org/support/topic-tag/string-replace/)

 * 7 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [7 years, 8 months ago](https://wordpress.org/support/topic/string-replace-2/#post-10689171)
 * Status: resolved