Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
there is a number value in a field called 'sales' as 555235. How to display the number in the format '555,235'?
num(Sales,'#,##0')
Thanks,
AS
This will make more sense
=Num(555235,'#,##,##0')
The above two serves the purpose but a little more elaborated for Num function
Num(number[, format[, dec_sep [, thou_sep]]])
Try like this
num(Sales,'###,##0')