separate the positions of a number in text box?

[Akina0929]

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,

[trdandamudi]

Use Num() function...

[Akina0929]

Hi Thirumala ,

I have used sum(sale amount) expression how to use number function with the expression please share me that expression.

[trdandamudi · Accepted solution]

=Num(Sum([sale amount]),'###,000')

or

=Num(Sum([sale amount]),'#,##,000')

[Akina0929]

Thankyou very much Thirumala.

[trdandamudi]

You are welcome...