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
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',',','''')
Try this by adding two single quotes in the format
This also seems to work
=Replace(num(100000, '#,##0'), ',', Chr(39))
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?
Would you be able to show where this isn't working in a dynamic expression? I believe it should work.
Retrieving data ...