Hello
>Woocommerce>Settings>General, section “Currency options”
Decimal separator = . ?
thanks, Alex
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.
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.
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.
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/
thanks, Alex
-
This reply was modified 7 years, 8 months ago by
algol.plus.
Thank you very much! I wouldn’t believe it was from the excel application the problem. Your support is awesome.. keep it up!
