How to change Amount format on BI publisher Translation output

Hello everyone,

We have some BI templates which need to be translated to French for French speaking Canadian users. For this purpose we have extracted translations, edited it by changing the target language to 'fr-CA' and updated target fields in the XSL file with French descriptions.

Everything works fine except the math numeric values with decimals. We want the amounts to print in the same format as English for eg 12,056.99 should print as 12,056.99 in translated output as well, instead it prints as 12 056,99

The source XML for French user is in English and shows the amount in the English format but somewhere due to the attached translation the amount format is changing. I know this is what French from France would probably want but should not apply to Canadian french.