Change value format

[#1]

How can I change value format 7270 to 7 270 and $17950390,380 to $17 950 390,380

Thx in advance

[swuehl]

Try

= Num( Sum(ListPriceProduct)*OrderQty, '# ###,#',',',' ')

[MarcoWedel]

‌use blank as additional thousands separator parameter in the num function.

[#4]

Thx but it does not work

[swuehl]

Hm, what do you mean with 'does not work'?

No result shown at all, wrong format or...?

Above works for me, e.g. in a text box, you might need to adapt the decimal place formatting, but thousand separator works as requested.

[#6]

The result is blank

[swuehl · Accepted solution]

Ah, ok, you copied my expression and a have a typo in the bracketing.

= Num( Sum([ListPriceProduct]*OrderQty), '# ###,###',',',' ')

[#8]

Perfect ! thank you

Stanley