Hi, Bob.

Thank you for reaching out to us.

Sorry for the late response.

Could you please send us your template, or if you used file-based source data so that we can take a closer look and try to isolate exactly what could be done to make a solution for you?

Hello Bob

Sorry for the late response.

The number format must be the same in wpDataTables, WordPress, and your local environment (PC, MS Office Suite, and so on). So if there are some settings different than in wpDataTables, the generated file may appear differently, like in your case. 

The thousand and decimal separators can't be removed from the formula columns, as they are saved as floats and do not inherit the number format from wpDataTables (as you said yourself, it "turns" itself on again).

This ticket has been forwarded to our developers, so hopefully they have a hot-fix for you.

Hi again Bob.

This needs to be done as custom work, which we do not provide support for.

You can try using the hook for the formula column, and for the table that you need. Just make sure to replace the table ID with the ID of the table that you need:

function removeSeparator ($formattedValue, $tableId){
    if ($tableId == 1){
        if (strpos($formattedValue,',') !== false) return str_replace(',','',$formattedValue);
    }
    
    return $formattedValue;
}
add_filter( 'wpdatatables_filter_formula_cell', 'removeSeparator', 10, 2 );

I hope this helps.