Thousand Separator
Hello,
I have a problem with a format number.
Could you tell me how is it possible to display a number with a special character in the ThousandSeparator field ? In this case the character is " ' " (for Switzerland), but it should be another character in function of the country.
I have a number on this format by default:
1234567.89
I want the format in function of the regional setting of the pc :
1'234'567.89 (for Switzerland)
1 234 567.89 (for France)
...
I tried to use the format %2.2n with " ' " in ThousandSeparator but there is no effect...
Do you have an idea ?
Thank you [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Best regards,[/img]
I have a problem with a format number.
Could you tell me how is it possible to display a number with a special character in the ThousandSeparator field ? In this case the character is " ' " (for Switzerland), but it should be another character in function of the country.
I have a number on this format by default:
1234567.89
I want the format in function of the regional setting of the pc :
1'234'567.89 (for Switzerland)
1 234 567.89 (for France)
...
I tried to use the format %2.2n with " ' " in ThousandSeparator but there is no effect...
Do you have an idea ?
Thank you [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Best regards,[/img]