High commas as thousands separator in text object

[stephanr]

Hi everyone

I try to format a number with the "num()"-function in a text object and I want to have high commas as thousands separator (e.g. 34'342'045). The problem is, that high commas are interpretet as "string end", so it doesn't work... Any ideas?

I Tried num(123456,'#'##0','.',''') with no effect

When I take num(123456,'#,##0','.',',') it shows 123,456 in the text object as expected

Thanks in advance,

Stephan

[#2 · Accepted solution]

Try this:

Replace(Num(35000,'###,###.'),',',Chr(39))

[stephanr]

You're a genious!

Thanks for the hint!

[stephanr]

It even works with

num((123456),'#'&Chr(39)&'##0','.',Chr(39))