Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a text box for sale amount.text box showing some number it's not separating hundreds, thousands positions with , please how can i separate please help me.
Thanking you,
=Num(Sum([sale amount]),'###,000')
or
=Num(Sum([sale amount]),'#,##,000')
Use Num() function...
Hi Thirumala ,
I have used sum(sale amount) expression how to use number function with the expression please share me that expression.
=Num(Sum([sale amount]),'###,000')
or
=Num(Sum([sale amount]),'#,##,000')
Thankyou very much Thirumala.
You are welcome...