Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Replace(Num(35000,'###,###.'),',',Chr(39))
You're a genious!
Thanks for the hint!
It even works with
num((123456),'#'&Chr(39)&'##0','.',Chr(39))