num Format

[madmax88]

hi,

How I get the Format 100'000 instead of 100,000?

In Num I can't write 3 times ' as '#'##0'.  e.g. num(sum(sales),'#'##0') doesn't work

[Gysbert_Wassenaar]

The num functions accepts a second and a third parameter for the decimal and thousands separators. Use these parameters, ie. num(100000, '000`000', ',', '`')

or if you want to use a single quote: num(100000,'000''000',',','''')

[sunny_talwar]

Try this by adding two single quotes in the format

Num(Sum(sales),'#''##0')

This also seems to work

=Replace(num(100000, '#,##0'), ',', Chr(39))

[madmax88]

Thanks, but it doesn't work in dynamic Expression.

E.g. i have 100'000, 10'000 and 1'000. Then your num Format are not working, right?

[sunny_talwar]

Would you be able to show where this isn't working in a dynamic expression? I believe it should work.