If I format a cell as a currency with symbol '$ French (Canada) the
custom format string generated is "#,##0.00 [$$-C0C]_-".. what does
the trailing minus sign do? It seems to have no effect when switching
between positive/negative/zero values..

Cheers,

Simon Thorn
XLCubed Ltd