Change the number format?

[Kohli]

there is a number value in a field called 'sales' as 555235. How to display the number in the format '555,235'?

[amit_saini]

num(Sales,'#,##0')

Thanks,

AS

[Anil_Babu_Samineni]

This will make more sense

=Num(555235,'#,##,##0')

[immkhan2]

The above two serves the purpose but a little more elaborated for Num function

Num(number[, format[, dec_sep [, thou_sep]]])

[avinashelite]

Try like this

num(Sales,'###,##0')