Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change value format 7270 to 7 270 and $17950390,380 to $17 950 390,380
Thx in advance
Ah, ok, you copied my expression and a have a typo in the bracketing.
= Num( Sum([ListPriceProduct]*OrderQty), '# ###,###',',',' ')
Try
= Num( Sum(ListPriceProduct)*OrderQty, '# ###,#',',',' ')
use blank as additional thousands separator parameter in the num function.
Thx but it does not work
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.
The result is blank
Ah, ok, you copied my expression and a have a typo in the bracketing.
= Num( Sum([ListPriceProduct]*OrderQty), '# ###,###',',',' ')
Perfect ! thank you
Stanley