How to format data numbers to Canadian French currency format?

[splambo]

In all French speaking organizations and countries, financial numbers are displayed with:

1. A space as the thousands separator

2. A comma as the decimal separator

Furthermore, in Canada, currency is displayed with the currency sign after a space after the number.

If I have 2553128457.75 in my data, I need it to be displayed as  2 553 128 457.75 $

1234.56 should be  1 234,56 $

And since we're on currency, the decimal should be rounded up to two decimal places: 9876.339 should be  9 876,34 $

I have been at this for hours and can't find a solution. What is the custom numeric format that will achieve this?

[Anonymous]

Hi @Greg_Deckler 

I have similar kind of problem.

In my case-

If I have 2553128457.75 in my data, I need it to be displayed as  2.553.128.457,75 $

Could you please help?

[Greg_Deckler · Accepted solution]

@splambo Try something like this:

### 000 000.00 \$;(\### 000 000.00 \$);\### 000 000.00 \$