Format a number with num() to use ' as separator in textbox

[peschu123]

Hi,

I use a Textbox to show a value.

The Value is something like "10123456" and I want it formatted like this: "T€ 10'123"

I played around with num() but the main problem is the ' (apostrophe) ...

I hope somebody can help me out.

Best Regards,

Peter

[#2]

Hi

the best is you set your format in tab 'number'  and copy it in your text box

best regards

Chris

[peschu123]

I tried that, but it doesn't work because of the apostrophe .. is there a way to escape this sign? chr(39) doesn't work inside num() too.

[bbi_mba_76]

Hi,

something like

num(10123456, 'T€ #''##0','.',chr(39)) ?

[marcus_sommer]

Try this:

= replace(num(10123456 / 1000, 'T€ #.##0'), '.', chr(39))

- Marcus

[rbecher]

Or this:

= num(floor(10123456 / 1000), 'T€ #'&chr(39)&'##0', '.', chr(39))

[peschu123]

Ok I got it working.

The best shot came from marcus, but I needed to change it a little bit to:

=replace(num(Sum({<[field1]={0}>}Costs)/1000, 'T€ #.##0',',','.'), '.', chr(39))

[rbecher]

..or better round than floor.

[rbecher]

But, you don't need replace..

[peschu123]

Yes!

It works very well, but floor leads to slightly wrong results...